Need to perform ORDER by Twice

Question

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

Answer 1

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

A good tutorial on this SQL ORDER BY