About sorting issues

Let's say there are 2 fields, 1 is the time, the ID.
ID time




I'd like to order by ID first.

3 444
3 555

2 222
2 333

And then order by time.

Become
3 444
3 555

2 333
2 222

How to write note 33 22 are grouped to sort the

Reply to discussion (solution)

If the final result is this, you can write the order by ID desc,time desc
3 555
3 444
2 333
2 222

Whether your request is:
Time Ascending of Odd ID
Time descending for even ID

If so, the order clause is:
ORDER BY id DESC, id%2

