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 vote179 views1 answer
How do I insert a blob in SQL?
SQL
0 vote181 views1 answer
Sql insert query list of dictionaries
SQL
0 vote159 views1 answer
Order by with where clause in mysql
SQL
0 vote205 views1 answer
SQL check if record exist
SQL
0 vote190 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote145 views1 answer
Check if record exists mysql
SQL
0 vote184 views1 answer
Mariadb change column type
SQL
2 votes147 views2 answers
Get all tables using like
SQL
92 votes1.7K views6 answers
Substring
SQL
8 votes165 views1 answer
Script to add datafile to tablespace
SQL