/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

1 vote271 views1 answer
Setval pgsql
SQL
5 votes251 views3 answers
Mysql update field from one table to another
SQL
5 votes253 views1 answer
How to check port number for postgresql
SQL
1 vote252 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote261 views1 answer
Postgres convert date to string
SQL
0 vote239 views1 answer
Sql right characters
SQL
0 vote248 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote266 views2 answers
Sql count number of rows after group by
SQL
0 vote259 views1 answer
View psql output in horizontal scrolling
SQL
0 vote264 views2 answers
How to know the character set of an oracle databes
SQL