/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

2 votes245 views1 answer
Show max_allowed_packet mysql
SQL
0 vote229 views1 answer
Drop index in sql
SQL
0 vote217 views1 answer
Check psql validity function
SQL
2 votes219 views1 answer
Oracle list grants on procedure
SQL
0 vote228 views1 answer
SQL authentication error
SQL
0 vote208 views1 answer
Ms sql unique
SQL
10 votes228 views2 answers
Linux command line import mysql database
SQL
0 vote221 views1 answer
Minecraft duping allowed servers
SQL
0 vote241 views2 answers
Dbms interview questions
SQL
0 vote247 views2 answers
Mysql dump database tables only
SQL