hey all, quick question.
I have a basic SQL query:
SELECT columns FROM table ORDER BY col1;
This returns the desired result, however now I want to do a second sort on the result, basically "ORDER BY col1, col2".
MySQL supports the syntax of "ORDER BY col1, col2", but this doesn't appear to return what I'm looking for. I have dug throught the docs but can't seem to find anything on the "ORDER BY col1, col2" syntax.
Can anyone help?
Thanks
I have a basic SQL query:
SELECT columns FROM table ORDER BY col1;
This returns the desired result, however now I want to do a second sort on the result, basically "ORDER BY col1, col2".
MySQL supports the syntax of "ORDER BY col1, col2", but this doesn't appear to return what I'm looking for. I have dug throught the docs but can't seem to find anything on the "ORDER BY col1, col2" syntax.
Can anyone help?
Thanks