That's why ORDER BY clause was invented in SQL, I guess. :pQuote:
Originally posted by stecal
Yes, but the days of the week are not in the order we normally associate with this type of list. Days of the week in alphabetical order does nothing for us in this query.
Usingdoesn't prevent you from adding an additional order by clause likeCode:group by to_char(hiredate, 'DAY')
Code:order by to_char(hiredate, 'D')