/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

6 votes179 views1 answer
Oracle rank
SQL
0 vote163 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote185 views4 answers
Forenkey code alchemy sql
SQL
0 vote207 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote186 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote207 views4 answers
Best data type to represent money in mysql
SQL
10 votes185 views2 answers
Rtrim sql
SQL
0 vote202 views1 answer
How to insert same table data using mysql query
SQL
2 votes165 views1 answer
Postgresql update sequence next value
SQL
0 vote183 views1 answer
Oracle sql add column auto generated value
SQL

Share