I want to group a weeks worth of data into the first day of the week specified such as the following:
Week 1________________Week 2
12/03/01 X____________12/10/01 O
12/04/01 O____________12/11/01 X
12/05/01 X____________12/12/01 O
12/06/01 O____________12/13/01 X
12/07/01 X____________12/14/01 O
12/08/01 O____________12/15/01 X
12/09/01 X____________12/16/01 O
12/03/01 X=4 O=3_____12/10/01 X=3 O=4
The bottom line is what I'm looking for. How can group a weeks worth of data at a time into sep. buckets?
maybe this cud help!!! in the query below, the count of employees who joined during the week will be displayed.
select trunc(hiredate,'WW'),count(*) from emp
group by trunc(hiredate,'WW')
In the group by clause mentioned above you need to add even the year part.
i.e select to_char(hiredate,'WW'),count(*) from emp
group by to_char(hiredate,'WW'),to_char(hiredate,'yyyy')
if you group by only week you might get incorrect results.
for ex: if you have to dates 12-JAN-1982 & 12-JAN-1983 it would treat both the dates as week no 4 but in reality they both are different. to avoid this you need to add the year part.
Click Here to Expand Forum to Full Width