Sort by mysql

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

Ascending order mysql

  
 SELECT 
   column_name1, column_name2, column_name3
FROM 
   table_name
ORDER BY 
   column_name1 [ASC|DESC], 
   column_name2 [ASC|DESC],
   ...;

Source: mysqltutorial.org

MySQL ORDER BY

SELECT 
   select_list
FROM 
   table_name
ORDER BY 
   column1 [ASC|DESC], 
   column2 [ASC|DESC],
   ...;

Source: mysqltutorial.org

MYSQL ORDER BY

SELECT * FROM adminra_RepAda.customerServiceRequests order by insertDate DESC;

Similar codes

5 votes280 views2 answers
Create table mysql example auto_increment
SQL
0 vote287 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote228 views1 answer
Delete all rows from table sqlite
SQL
1 vote265 views1 answer
Sqlite show columns in table
SQL
0 vote271 views1 answer
Kill a pid redshift
SQL
0 vote248 views1 answer
How to count with except in psql
SQL
10 votes277 views2 answers
SQL rounding numbers
SQL
0 vote294 views1 answer
Remove mysql from centos 7
SQL
0 vote299 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote252 views2 answers
Plsql function that return a table
SQL