Total number of requests per day of the week

[jmodic]

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.

That's why ORDER BY clause was invented in SQL, I guess.

Using

group by to_char(hiredate, 'DAY')

doesn't prevent you from adding an additional order by clause like

order by to_char(hiredate, 'D')

[stecal]

Okay, I am willing to let this one go now.

[skanth76]

select Weekday, Hired
from(select to_char(hiredate, 'D'),to_char(hiredate, 'DAY') WEEKDAY, count(*) hired
from emp
group by to_char(hiredate, 'D'),to_char(hiredate, 'DAY')) dTab

[jmodic]

Originally posted by skanth76
select Weekday, Hired
from(select to_char(hiredate, 'D'),to_char(hiredate, 'DAY') WEEKDAY, count(*) hired
from emp
group by to_char(hiredate, 'D'),to_char(hiredate, 'DAY')) dTab

But of course! Why make it simple if you can make it complicated!

[stecal]

I thought this horse was dead already...