sql, order by column A and then by column B

sql sqlite select
pierrotlefou picture pierrotlefou · Nov 9, 2009 · Viewed 73.7k times · Source

How to write the sql so that the result can be ordered first by column A than by column B. Something like below:

SELECT * FROM tbl WHERE predictor ORDER by col_A and ORDER by col_B

Answer

James McNellis picture James McNellis · Nov 9, 2009 
ORDER BY col_A, col_B

The SQLite website has syntax diagrams explaining the SQL grammar supported by SQLite.

Related questions

SQLite select where empty?

In SQLite, how can I select records where some_column is empty? Empty counts as both NULL and "".

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More