/SQL/Mysql order by where condition sub query

Mysql order by where condition sub query

SELECT orders.status, orders.created_at
FROM `orders`
ORDER BY
  status='new' DESC,
  status='processing' DESC,
  CASE WHEN status IN ('new', 'processing') THEN created_at END ASC,
  CASE WHEN status NOT IN ('new', 'processing') THEN created_at END DESC

Similar codes

3 votes164 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote139 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote163 views1 answer
Find duplicate users by email address in mysql
SQL
2 votes176 views1 answer
Find column in all stored procedures sql server
SQL
1 vote159 views1 answer
Postgresql create table with timestamp
SQL
4 votes139 views1 answer
Select nls_date_format
SQL
7 votes157 views3 answers
Sql set
SQL
8 votes141 views2 answers
Select table column name in sql
SQL
3 votes174 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote143 views2 answers
How to update date in oracle
SQL