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 vote248 views1 answer
Postgresql create table default value timestamp
SQL
0 vote253 views1 answer
Postgres select except
SQL
1 vote287 views1 answer
Sql count value greater than
SQL
0 vote261 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote295 views1 answer
Java sql timestamp now
SQL
0 vote278 views1 answer
Best sql collation
SQL
4 votes243 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
-1 vote303 views3 answers
MAKE TABLE FIT in oracle sql
SQL
3 votes273 views1 answer
Select database in sql
SQL
1 vote277 views1 answer
Mysql size int
SQL