SELECT category 
FROM
    (SELECT  Category
     FROM Table
     ORDER BY 
         CASE
             WHEN Category = 'A' THEN 1
             WHEN Category = 'C' THEN 2
             WHEN Category = 'D' THEN 3
             WHEN Category = 'e' THEN 4) a
ORDER BY 
    Category