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

2 votes175 views1 answer
Ssh mysql port forwarding
SQL
2 votes187 views4 answers
Mysql get all tables row count
SQL
1 vote186 views3 answers
Mysql parse int
SQL
11 votes210 views5 answers
Laravel db facade
SQL
0 vote180 views1 answer
Oracle right characters
SQL
0 vote200 views1 answer
Shows all databases created by user in ms sql
SQL
1 vote182 views1 answer
How to find median of a column sql
SQL
0 vote147 views2 answers
Avg() sql
SQL
2 votes183 views1 answer
Sql update from different table
SQL
0 vote182 views1 answer
Mariadb current date plus 1 day
SQL