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

0 vote254 views1 answer
Mysql join same table multiple times group by
SQL
5 votes264 views2 answers
Create function postgresql
SQL
1 vote265 views1 answer
Oracle drop job if exists
SQL
0 vote235 views2 answers
Change database postgres
SQL
0 vote267 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote256 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote261 views1 answer
Mysql root permission denied lost
SQL
5 votes240 views3 answers
Mysql check if null or empty string
SQL
0 vote252 views1 answer
Mysql search multiple tables
SQL
2 votes265 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL