Answers for "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

Posted by: Guest on May-18-2021

Code answers related to "mysql order by where condition sub query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql order by where condition sub query"

Code answers related to "mysql order by where condition sub query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql order by where condition sub query"

Code answers related to "mysql order by where condition sub query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us