How to get results in a custom order? [closed]

by 
SELECT * FROM Customers
ORDER BY case when country = 'P' then 1
              when country = 'A' then 2
              when country = 'L' then 3
              when country = 'H' then 4
              else 5
         end asc

More Related Contents:

  1. When no ‘Order by’ is specified, what order does a query choose for your record set?
  2. How to update and order by using ms sql
  3. SQL Server UNION – What is the default ORDER BY Behaviour
  4. “Order By” using a parameter for the column name
  5. how does SELECT TOP works when no order by is specified?
  6. Dynamic order direction
  7. SQL QUERY COUNT THEN ADD
  8. SQL server command help and tutorials for specific commands?
  9. How do I UPDATE from a SELECT in SQL Server?
  10. CROSS JOIN vs INNER JOIN in SQL
  11. Referring to a Column Alias in a WHERE Clause
  12. INNER JOIN vs LEFT JOIN performance in SQL Server
  13. Function vs. Stored Procedure in SQL Server
  14. SQL Query – Using Order By in UNION
  15. What’s the best way to select the minimum value from several columns?
  16. Counting DISTINCT over multiple columns
  17. How to check if a stored procedure exists before creating it
  18. Insert Into… Merge… Select (SQL Server)
  19. Correct use of transactions in SQL Server
  20. The parameterized query expects the parameter which was not supplied
  21. SQL Server converting varbinary to string
  22. SSIS Source Format Implicit Conversion for Datetime
  23. UNION the results of multiple stored procedures
  24. Executing SQL Server Agent Job from a stored procedure and returning job result
  25. Compare dates in T-SQL, ignoring the time part
  26. SQL ORDER chars numerically
  27. Should I use the CASCADE DELETE rule? [duplicate]
  28. Why is RAND() not producing random numbers?
  29. SQL, How to Concatenate results?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment