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 vote126 views1 answer
Apt install sql server
SQL
4 votes153 views2 answers
Postgresql float data type
SQL
0 vote129 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote137 views1 answer
How to insert multiple values in a single column in sql
SQL
1 vote71 views1 answer
Python escape string for sql
SQL
0 vote113 views1 answer
Insert thai language sql server
SQL
0 vote108 views1 answer
Get first name and last name from full name string in SQL
SQL
2 votes110 views1 answer
Create table with primary key
SQL
104 votes195 views2 answers
Like in mysql
SQL
0 vote126 views2 answers
Postgresql get last day of month
SQL