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

0 vote172 views1 answer
Mysql function variable
SQL
4 votes191 views3 answers
Sql drop database if exists
SQL
7 votes171 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote136 views1 answer
Plsql trigger insert update
SQL
24 votes189 views4 answers
Delete db postgres
SQL
24 votes178 views5 answers
Sql server insert into select
SQL
1 vote202 views1 answer
Liquibase alter column type / length
SQL
0 vote191 views1 answer
Create function in microsoft sql server
SQL
0 vote180 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote188 views1 answer
Sql decode
SQL