Sample Table:
SELECT * FROM COUNTRY
NAME |
CANADA |
ENGLAND |
INDIA |
IRAN |
MISR |
PAKISTAN |
SHAAM |
For the above shown table i want the result in such a way that a particular country should be listed first and then the remaining countries should be sorted in ascending order.
As for example I want "SHAMM" to be listed first and the remaining countries should be sorted in ascending order.
SELECT * FROM COUNTRY
ORDER BY CASE WHEN NAME = 'SHAAM' THEN 1 ELSE 2 END,NAME ASC
NAME |
SHAAM |
CANADA |
ENGLAND |
INDIA |
IRAN |
MISR |
PAKISTAN |
In the above query we have highlighted the use of case statement in order by.