I have a table column 'STATUS' with the following possible Data.
I want to Sort the table, but placing Closed on top, and Cancelled last, the other Status type should be Sorted by a Date column.
Is it possible to achieve this in SQL? I'm using SQL 2005.
SELECT * from TABLE_A ORDER BY (Closed on top, Cancelled below, others by Date)