I have a MySQL table, and i'm trying to figure how can i get the first result for each user.
For example:
Email Time DateSubmission
usera@email.com | 0:14 | 28/2/2019 00:10
usera@email.com | 0:10 | 28/2/2019 00:08
usera@email.com | 0:10 | 29/2/2019 00:10
userb@email.com | 0:10 | 28/2/2019 00:04
userb@email.com | 0:11 | 28/2/2019 00:17
userc@email.com | 0:11 | 28/2/2019 00:18
I've tried to use distinct, order by's but can't find how to get results like:
Email Time DateSubmission
userb@email.com | 0:10 | 28/2/2019 00:04
usera@email.com | 0:10 | 28/2/2019 00:08
userc@email.com | 0:11 | 28/2/2019 00:18
Can anyone help?