Help - Group data by week?

[mrpaulwass]

Help,

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?

Thanks,

Paul

[balajiyes]

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')

[yejurvad]

Hi

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.

Regards,
Raghav.