title: PostgreSQL Selecting Most Recent Entry for a Given ID
body: <p>Table Essentially looks like:</p>
  
  <p>Serial-ID, ID, Date, Data, Data, Data, etc.</p>
  
  <p>There can be Multiple Rows for the Same ID. I'd like to create a view of this table to be used in Reports that only shows the most recent entry for each ID. It should show all of the columns. </p>
  
  <p>Can someone help me with the SQL select? thanks.</p>