Hello guys,
I am having trouble solving the following problem.
Raw data table
ID. NAME. TIMESTAMP.
1. Tim. 14:00
2. Eve. 15:00
3. Tim. 15:10
4. Tim. 15:30
5. Eve. 16:00
Expected result after query
ID. NAME. TIMESTAMP.
5. Eve. 16:00
2. Eve. 15:00
4. Tim. 15:30
3. Tim. 15:10
1. Tim. 14:00
So the objective is to get most recent row order by TimeStamp but group the results with name.