title: MySQL Syntax to Get First Record for Each Group
body: <p>Have a table that is ID (PK), Email, Timestamp. Many records for each email. Want to be able to pull the first chronological record for each day (based on timestamp) for each email. ID may or may not be in chronological order, so can't rely on that. Having a brain fart on syntax to do so...recordset should include 1 record for each email for each day.</p>
  
  <p>Thanks in advance.</p>