It is necessary to fulfill the ORDER twice

Question

I want to sort according to the date first, and then if the date is similar, then according to id .. How to do this in an Informix / HSQL query?

Answer 1

SELECT FIELD1, FIELD2 FROM TABLE ORDER BY FIELD1 ASC, FIELD2 ASC

Good tutorial on this SQL ORDER BY

Answer 2

Try this (according to your needs):

SELECT * FROM table ORDER BY datecol ASC, id ASC

Answer 3

This should work:

SELECT * FROM Table
ORDER BY date, id;

Answer 4

whether

[rest of query] order by date, id

Job?

Answer 5

select * from (select * from the list of tabs by col1) order by col2