select DISTINCT dt,
sum(decode(item,'办公用品',fee)) OVER(PARTITION BY DT) 办公用品总费用,
sum(decode(item,'工资',fee)) OVER(PARTITION BY DT) 工资总费用
from item
SELECT STATEMENT, GOAL = ALL_ROWS
Cost=4
Cardinality=4
Bytes=116
HASH UNIQUE
Cost=4
Cardinality=4
Bytes=116
WINDOW SORT
Cost=4
Cardinality=4
Bytes=116
TABLE ACCESS FULL
Object owner=SYSTEM
Object name=ITEM
Cost=2
Cardinality=4
Bytes=116 |