/SQL/Mysql order by list

Mysql order by list

MySQL ORDER BY

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

3

Source: mysqltutorial.org

MYSQL ORDER BY

SELECT * FROM adminra_RepAda.customerServiceRequests order by insertDate DESC;

0

Mysql order by list

ORDER BY FIELD(id, 3, 11, 7, 1)

0

Source: stackoverflow.com

Similar codes

0 vote135 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote120 views1 answer
Where in clause tsql
SQL
0 vote133 views1 answer
Implicit inner join table alias with id values
SQL
2 votes127 views1 answer
Set column to not null mysql
SQL
1 vote142 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote128 views1 answer
Sql server datetime to string
SQL
0 vote136 views1 answer
Sql cnvert bit to nvarchar
SQL
-1 vote181 views5 answers
Left join sql
SQL
0 vote142 views1 answer
Sql from null to not null
SQL
0 vote128 views1 answer
Update top 100 order by sql server
SQL

Share