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

15 votes255 views3 answers
Find duplicate keys in mysql
SQL
1 vote251 views1 answer
Increase existing date in sql oracle
SQL
0 vote258 views1 answer
Check if record exists mysql
SQL
20 votes260 views3 answers
SQL query rename table
SQL
0 vote262 views1 answer
Database traccar
SQL
1 vote249 views1 answer
Mysql get character set
SQL
9 votes276 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote247 views1 answer
Add unique constraint sql server multiple columns
SQL
4 votes244 views3 answers
Mysql varchar length
SQL
3 votes235 views3 answers
Docker create postgresql database
SQL