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

1 vote292 views1 answer
Sql group by sum with condition
SQL
2 votes254 views1 answer
Convert series number to date in sql
SQL
7 votes284 views2 answers
Show size database mysql
SQL
0 vote287 views1 answer
Mysql subdate
SQL
0 vote328 views1 answer
Mysql get nth highest
SQL
-1 vote285 views1 answer
Mysql case when multiple conditions
SQL
0 vote269 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
3 votes234 views1 answer
How to get list of synonyms in oracle
SQL
0 vote312 views1 answer
Add new column in sql with foreign key
SQL
3 votes426 views9 answers
Linq to sql converter online
SQL