query help - to get detail record whose datewise sum >= 5000
hi friends , this is my query
SELECT TXD_SEQ,TXD_DATE,SUM(TXD_AMT) A
,MAX(TDS_FLG),GROUPING(TXD_SEQ) B
FROM NIS.FDRINTMAST F,(SELECT DISTINCT P.START_DT,P.END_DT
FROM NIS.PERIODMAST P,NIS.FDRINTMAST M
WHERE M.TXD_PERD(+)=P.PERD_CODE
AND PERD_TYPE='Y'
START WITH PERD_CODE=M.TXD_PERD
CONNECT BY PRIOR P.PARENT_PERD=P.PERD_CODE) T
/*,( SELECT P1.PERD_CODE,P.PARENT_PERD,P1.START_DT,P1.END_DT
FROM NIS.MMMMAST M,NIS.PERIODMAST P,NIS.PERIODMAST P1
WHERE TXN_DOC='FDR'
AND M.PERD_CODE=P.PERD_CODE
AND P1.PERD_CODE=P.PARENT_PERD
) T*/
WHERE TO_CHAR(TXD_DATE,'YYYYMMDD') BETWEEN TO_CHAR(T.START_DT,'YYYYMMDD') AND TO_CHAR(T.END_DT,'YYYYMMDD')
GROUP BY TXD_DATE,ROLLUP(TXD_SEQ)--,TDS_FLG
THE OUTPUT OF THE QUERY IS
seq Date Amount flg grouping(seq)
10539997 3/31/2007 1566 N 0
3/31/2007 1566 N 1
10539997 3/31/2008 1922 Y 0
10539998 3/31/2008 3665 N 0
3/31/2008 5587 Y 1
BUT I WANT detail record WHOSE DATEWISE SUMMARY is greater than 5000 means
the output should be
10539997 3/31/2008 1922 Y 0
10539998 3/31/2008 3665 N 0
. how could i get this answer
Edited by: user10685034 on 05-Mar-2009 20:49