SELECT * FROM
(
SELECT 'I.Sc.' AS Qualification
UNION
SELECT 'B.Sc.' AS Qualification
UNION
SELECT 'Other' AS Qualification
UNION
SELECT 'P.G.' AS Qualification
UNION
SELECT 'MCA' AS Qualification
UNION
SELECT 'DCA' AS Qualification
UNION
SELECT 'P.H.D' AS Qualification
) AS TBL
ORDER BY CASE WHEN Qualification='Other'
THEN 'ZZZZZ' ELSE Qualification END
No comments:
Post a Comment