/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 vote225 views1 answer
Oracle sql create or replace view
SQL
0 vote242 views1 answer
How to close external sql connection in laravel
SQL
0 vote227 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote231 views2 answers
Mysql disable foreign key checks
SQL
13 votes223 views5 answers
Oracle list tables
SQL
1 vote235 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote231 views1 answer
Sql string contains case sensitive
SQL
4 votes236 views3 answers
Oracle sql first day of quarter
SQL
0 vote237 views1 answer
Postgres data location
SQL
0 vote225 views1 answer
Dns slave zone convert
SQL