/
Question & Réponse
/
How to Using ORDER BY with CASE in SQL Queries

How to Using ORDER BY with CASE in SQL Queries

Sql, Mysql
Base de données

--Simple sort by ORDER BY
SELECT FirstName, LastName
FROM Person
ORDER BY FirstName

-- ORDER BY with CASE
SELECT FirstName, LastName
FROM Person
ORDER BY CASE LastName
        WHEN 'Wright'  THEN '0'
        WHEN 'Jenkins' THEN '1'
        WHEN 'Torres'  THEN '2'
        WHEN 'Sanchez' THEN '3'
        ELSE LastName
END

-- Multiple column sort with ORDER BY with CASE
SELECT FirstName, LastName
FROM Person
ORDER BY CASE LastName
        WHEN 'Wright'  THEN '0'
        WHEN 'Jenkins' THEN '1'
        WHEN 'Torres'  THEN '2'
        WHEN 'Sanchez' THEN '3'
        ELSE LastName
END, FirstName