Tag archive for ‘CASE’
Order by day column using SQL
If you’ve ever had to sort a SQL query’s resultset using an “order by” clause on a “day of the week” column then you will know it can be very easy, or very tricky, depending on the format that the day is stored in the database. If you stored the day of the week in [...]