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 vote343 views1 answer
Watch mysql command line
SQL
1 vote316 views1 answer
Mysql show table character set
SQL
1 vote321 views1 answer
Events mysql
SQL
0 vote329 views1 answer
Postgres read table structure
SQL
0 vote299 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
-1 vote258 views1 answer
Mysql how to set update or create
SQL
0 vote356 views3 answers
Java hide mysql login credentials
SQL
0 vote320 views1 answer
Sql recherche nom prenom
SQL
2 votes355 views1 answer
Postgresql create table as select
SQL
0 vote318 views1 answer
Grouping by email domain mysql
SQL