title: SQL select row with max date from table
body: <p>I need to create a query where I get the row with the most recent time stamped date. I know <code>MAX</code> cant be used in a <code>WHERE</code> clause but I would need something like this:</p>
  
  <pre><code>SELECT * FROM data WHERE MAX(timestamp)
  </code></pre>