title: BigQuery - Select only first row in BigQuery
body: <p>I have a table with data where in Column A I have groups of repeating Data (one after another).</p>
  
  <p>I want to select only first row of each group based on values in column A only (no other criteria). Mind you, I want all corresponding columns selected also for the mentioned new found row (I don't want to exclude them).</p>
  
  <p>Can someone help me with a proper query.</p>
  
  <p>Here is a sample:
  <a href="https://i.stack.imgur.com/96giP.png" rel="noreferrer">SAMPLE</a></p>
  
  <p>Thanks!</p>