RicardoBett

Hello, thank you for your help.🙂 Unfortunately i couldn't make it work either. 

Thank you for your reply. 

But suppose that we insert new record "Tim" at 18:00.

Now I want to show Tim first because he has the most recent timestamp. And only after showing all Tim records the. Show Eve

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.