title: Latest date and time in SQL without ORDER BY
body: <p>I'm trying to find a way to display the last event held (last date and time) in an events table whilst displaying all the columns for that event without using ORDER BY.</p>
  
  <p>For example: </p>
  
  <pre><code>SELECT * from Events
  where dateheld in (select max(dateheld) from events)
  AND starttime in (select max(starttime) from events)
  </code></pre>
  
  <p>When I put MAX starttime, it displays nothing. When I put MIN starttime it works but displays the earliest time of that date and not the latest.</p>