title: Google Sheets QUERY most recent unique entries
body: <p>I am trying to use the QUERY function on a list of Google Form responses to only display the most recent of unique entries(based on the key Student ID).</p>
  
  <pre><code>A = Timestamp Column 
  C = Student ID Column
  </code></pre>
  
  <p>Using:</p>
  
  <pre><code>select max(A)
  group by C
  </code></pre>
  
  <p>I was able to get the right entries, but only one column for each(<strong>I want all the data, the whole row, from the right entries</strong>)</p>
  
  <p>So I tried using:</p>
  
  <pre><code>select max(A),B,C,D,E,F,G,H 
  group by C
  </code></pre>
  
  <p>But this gives an error</p>
  
  <blockquote>
    <p>Unable to parse query string for Function QUERY parameter 2:
    ADD_COL_TO_GROUP_BY_OR_AGGB</p>
  </blockquote>
  
  <p>I am new to databases, first time using QUERY. Sorry if this is confusing, but maybe the sheet makes more sense:
  <a href="https://docs.google.com/spreadsheets/d/1X1QWNV3IrMKqhhauF32y4HKEi2ktGJXQI9S3JZphqMw/edit?usp=sharing" rel="nofollow">spreadsheet</a></p>