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