/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

0 vote286 views1 answer
Mariadb hours between two dates
SQL
0 vote286 views1 answer
Sql server select furst day of current year
SQL
1 vote295 views1 answer
Postgresql pass array in function
SQL
1 vote288 views1 answer
Select not matching data with join table
SQL
1 vote273 views1 answer
Sql oracle update multiple rows
SQL
1 vote229 views1 answer
Prevent duplicate rows in postgres
SQL
-1 vote288 views3 answers
SQL to LINQ converter
SQL
3 votes279 views2 answers
Oracle synonym
SQL
0 vote359 views1 answer
Redshift running queries
SQL
2 votes269 views1 answer
Username sql
SQL