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 vote110 views1 answer
Where name ends in SQL
SQL
1 vote110 views1 answer
Oracle check table lock
SQL
0 vote74 views1 answer
Sql runnignsum
SQL
7 votes121 views2 answers
Create index mysql cli
SQL
18 votes103 views2 answers
Sql inner join
SQL
0 vote115 views1 answer
Oracle list partitions
SQL
0 vote93 views1 answer
Oracle 11g forget password
SQL
7 votes115 views3 answers
Convert ansi sql
SQL
0 vote94 views5 answers
Sql table intermédiaire
SQL
7 votes115 views5 answers
Max 3 salary in sql
SQL