title: Select a Column in SQL not in Group By
body: <p>I have been trying to find some info on how to select a non-aggregate column that is not contained in the Group By statement in SQL, but nothing I've found so far seems to answer my question. I have a table with three columns that I want from it. One is a create date, one is a ID that groups the records by a particular Claim ID, and the final is the PK. I want to find the record that has the max creation date in each group of claim IDs. I am selecting the MAX(creation date), and Claim ID (cpe.fmgcms_cpeclaimid), and grouping by the Claim ID. But I need the PK from these records (cpe.fmgcms_claimid), and if I try to add it to my select clause, I get an error. And I can't add it to my group by clause because then it will throw off my intended grouping. Does anyone know any workarounds for this? Here is a sample of my code:</p>
  
  <pre><code>Select MAX(cpe.createdon) As MaxDate, cpe.fmgcms_cpeclaimid 
  from Filteredfmgcms_claimpaymentestimate cpe
  where cpe.createdon &lt; 'reportstartdate'
  group by cpe.fmgcms_cpeclaimid
  </code></pre>
  
  <p>This is the result I'd like to get:</p>
  
  <pre><code>Select MAX(cpe.createdon) As MaxDate, cpe.fmgcms_cpeclaimid, cpe.fmgcms_claimid 
  from Filteredfmgcms_claimpaymentestimate cpe
  where cpe.createdon &lt; 'reportstartdate'
  group by cpe.fmgcms_cpeclaimid
  </code></pre>