title: How do I select the rows with the most recent date in SQL?
body: <p>I have a table that has columns <code>employee_id</code>, <code>status</code>, and <code>update_date</code>. I'm trying to select all three columns on the condition that the <code>update_date</code> has to be the most recent (the values for status are initiated, completed, and not_applicable, so depending on that an employee_id could appear 3 times in the table).</p>
  
  <p>The table has around 300 rows, but I know the output should contain around 50. I am very new to SQL. </p>
  
  <p>The query I've tried is:</p>
  
  <pre><code>select employee_id, status, update_date 
  from data 
  where update_date = max(update_date)
  </code></pre>