mysql order by where condition sub query

Solutions on MaxInterview for mysql order by where condition sub query by the best coders in the world

Search
showing results for - "mysql order by where condition sub query"
Leonie
28 Oct 2017
1
2SELECT orders.status, orders.created_at
3FROM `orders`
4ORDER BY
5  status='new' DESC,
6  status='processing' DESC,
7  CASE WHEN status IN ('new', 'processing') THEN created_at END ASC,
8  CASE WHEN status NOT IN ('new', 'processing') THEN created_at END DESC
9
similar questions
sql order by where conditionsort by mysqlmysql multiple order bymysql order by multiple columnsmysql sort descendingsort by myqslorder by value mysqlmysql order by on conditionmysql order bysqlalchemy order by descendingmysql order byorder by with where clause in mysqlmysql order by two columns prioritymysql order by listmultiple order by sqlmysql sort by date columncondition in orderby mysqlmysql order bysqlalchemy order bymysql order by fieldmysql where in keep ordermysql orderalphabetical order mysqlmysql where in maintain orderascending order mysql
queries leading to this page
mysql order by where condition sub querymysql order by where condition sub query