SELECT a.RESTCD, a.CONERCD, a.DEALDAY, a.taxamt , sum(b.taxamt)
from
(
SELECT RESTCD, CONERCD, DEALDAY,taxamt ,rownum as num
FROM DSALE_VP@RH2DB
WHERE restCd = 'S55189A'
AND dealDay = '20051206'
) a ,
(
SELECT RESTCD, CONERCD, DEALDAY,taxamt ,rownum as num
FROM DSALE_VP@RH2DB
WHERE restCd = 'S55189A'
AND dealDay = '20051206'
) b
where a.num >= b.num
group by a.RESTCD, a.CONERCD, a.DEALDAY, a.taxamt ;
|
|
|