/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

14 votes336 views4 answers
Online sql compiler
SQL
0 vote371 views1 answer
Dataframe lambda elif
SQL
11 votes370 views1 answer
Oracle export view ddl
SQL
20 votes361 views6 answers
Change password in mysql
SQL
4 votes371 views1 answer
Mysql query first character
SQL
0 vote356 views1 answer
Running mysql from bash sc
SQL
0 vote330 views1 answer
Ksql quickstart docker
SQL
0 vote348 views1 answer
Psql generate id in existing database
SQL
0 vote341 views1 answer
SQL Server Enterprise
SQL
4 votes319 views2 answers
Mysql show indexes on table
SQL