Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

data group by weeks of a month

teefu ghulamNov 9 2016 — edited Nov 11 2016

dear members

i am using 10gR2 db.

Field in my table are

TR_DATE  DATE,

QTY          NUMBER

REQUIRED OUTPUT FOR THE MONTH OF NOV-2016 ( 5 weeks in this month)

TR_DATE          QTY

01-11-2016          20

02-11-2016          10

03-11-2016          30

04-11-2016          10

05-11-2016          15

SUB TOTAL          85

TR_DATE            QTY

06-11-2016          10

07-11-2016          10

08-11-2016          10

09-11-2016          10

10-11-2016          10

11-11-2016          10

12-11-2016          10

SUB TOTAL          70

13 TO 19

SUB TOTAL

20 TO 26

SUB  TOTAL

27 TO 30

SUB TOTAL

GRAND TOTAL

thanks

teefu

lahore pakistan

This post has been answered by Frank Kulash on Nov 9 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2016
Added on Nov 9 2016
26 comments
13,930 views