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

Answer 2

This should work:

SELECT * FROM Table
ORDER BY date, id;

Answer 3

Does

[rest of query] order by date, id

work?

Answer 4

select * from (select * from tablename order by col1) AS T order by col2

(It's necessary to give an alias to the virtual table, hence "AS T")

Answer 5

Try this(adjusted to your needs):

SELECT * FROM table ORDER BY datecol ASC, id ASC

Answer 6

select * from (select * from tablename order by col1) AS T order by col2

This works but is redundant and obtuse. Note the subquery (on "col1") becomes the secondary sort; the primary sort is the encompassing query. Some environments may require the "as T" aliasing of the subquery, but not all.

select * from tablename order by col2, col1

This does the same thing as above, with simple clarity

Or for a more realistic example:

select * from customers order by lastname, firstname