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

6 votes156 views1 answer
Postgresql add enum value
SQL
3 votes149 views2 answers
Sql end of month
SQL
1 vote186 views1 answer
Mysql tables max count
SQL
8 votes148 views1 answer
Ltrim sql
SQL
3 votes156 views1 answer
Sql print all names that start with a given letter
SQL
3 votes158 views6 answers
DB::table('users')->get();
SQL
0 vote148 views1 answer
Sqlcmd no headers
SQL
7 votes145 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote173 views1 answer
Using distinct and count together in sql
SQL
1 vote156 views1 answer
Mysql select if empty result
SQL