Sql order by multiple columns

SELECT * FROM table_name ORDER BY col1 ASC;				-- ASCending is default
SELECT * FROM table_name ORDER BY col1 DESC;			-- DESCending
SELECT * FROM table_name ORDER BY col1 DESC, col2;		-- col1 DESC then col2 ASC

Sort order on two columns sql

Sort by multiple column : ORDER BY column1 DESC, column2

Similar codes

3 votes203 views1 answer
Select sequence oracle
SQL
4 votes181 views2 answers
Sql select except null
SQL
0 vote183 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote183 views1 answer
Fetch second word from a string in ms sql
SQL
5 votes203 views3 answers
Sql max value in column
SQL
0 vote207 views1 answer
T-sql delete view if exists
SQL
0 vote207 views2 answers
How covert into int in maria db
SQL
0 vote189 views1 answer
Postgre admin slow
SQL
4 votes568 views1 answer
Oracle show errors
SQL
0 vote193 views2 answers
How to save result of sqlite query in a table
SQL