Get only latest row, grouped by a column
- by Cylindric
I have a large data-set of emails sent and status-codes.
ID Recipient Date Status
1 someone@example.com 01/01/2010 1
2 someone@example.com 02/01/2010 1
3 them@example.com 01/01/2010 1
4 them@example.com 02/01/2010 2
5 them@example.com 03/01/2010 1
6 others@example.com 01/01/2010 1
7…