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 vote190 views1 answer
Linebreak sql
SQL
0 vote207 views1 answer
Tsql pad left
SQL
1 vote183 views1 answer
Mysql select row max date
SQL
0 vote194 views1 answer
Max mysql
SQL
11 votes321 views2 answers
Import mysql dump command line windows
SQL
2 votes206 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote289 views1 answer
Site:av.ru "files"
SQL
3 votes192 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote175 views1 answer
Calculate date and convert to yearsmysql
SQL
58 votes560 views4 answers
Mysql drop column
SQL