by 쓰쓰니 [SQL Query] [2017.07.25 09:31:33]
-
select yy , min(decode(pro,'과자' , in )) "과자입고" , min(decode(pro,'과자' , out)) "과자출고" , min(decode(pro,'음료' , in )) "음료입고" , min(decode(pro,'음료' , out )) "음료출고" from 테이블 group by yy