Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Group resultset day by day
Hi, I'm searching for a better way to do a procedure that SELECTs some
data of a specific month and bring the resultset with the value grouped
day by day.
My tables:
TBL_Activity
TBL_WorkingTime
ID_WorkingTime DT_DateTime NR_HoursSpent ID_Activity
So, I need to get from all the activities (TBL_Activity) the sum of the NR_HoursSpent grouped by every month day.
I need to have a resultset like this:
ID_Activity | NM_Activity | Day 01 | Day 02 | Day 03 | and son on, up to the last month day | Day 31
And for every Day, I get the sum of the NR_HoursSpent for that day.
How can I do this? Received on Thu Sep 14 2006 - 14:44:13 CDT
![]() |
![]() |