Ascending order mysql

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 vote153 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
1 vote162 views1 answer
Does insert into overwrite sql
SQL
3 votes147 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote151 views1 answer
ORA-13717
SQL
3 votes119 views2 answers
Coalesce mysql
SQL
0 vote148 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
11 votes146 views5 answers
How to install sqlite3 python
SQL
0 vote171 views1 answer
Show all sequences postgres
SQL
0 vote143 views1 answer
Automate mysql cli query
SQL
4 votes161 views3 answers
Sqlite show columns
SQL