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 vote201 views1 answer
Sql query to get contact form 7 fields
SQL
1 vote184 views1 answer
Sql avg group by
SQL
3 votes193 views2 answers
Get current year sql
SQL
1 vote238 views3 answers
Nth highest salary
SQL
10 votes193 views4 answers
Primary key sql
SQL
0 vote185 views1 answer
Mysql add to value
SQL
6 votes200 views1 answer
Oracle rank
SQL
1 vote203 views1 answer
Snowflake rename column name
SQL
0 vote204 views1 answer
Get id if is not equal in certain table
SQL
2 votes191 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL