시소당
Select saledept,
Sum(decode(saledate, to_char(sysdate,’yyyymmdd’), chulqty,0)) as ‘당일합계’
,Sum(decode(sign(8-(sysdate-to_date(saledate,’yyyymmdd’))),1,chulqty)) as ‘일주일분합계’
,substr(max(saledate||chulqty),9,20) as ‘최근최고분’
,sum(saleamt) as ‘월간합계’
from 판매테이블
where saledate like ‘9610%’
group by saledept;