-
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
-
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')
Cheers!
OraKid.
-
Group Data
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|