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 vote133 views1 answer
Sql DATE = GETDATE()
SQL
4 votes137 views1 answer
Update table from another table oracle
SQL
-1 vote143 views2 answers
First letter capital in mysql query
SQL
0 vote144 views1 answer
How to print some string in mysql
SQL
1 vote179 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote144 views1 answer
Sql script to remove default from column
SQL
1 vote130 views1 answer
Sql headers delphi
SQL
0 vote139 views1 answer
Postgresql remove new line from string
SQL
5 votes131 views2 answers
Add column postgres with default value
SQL
0 vote131 views1 answer
Sql make sure every user is unqiuew
SQL