SELECT acc_nbr,
SUM (DECODE (acct_item_, 2005, NVL(charge,0))),
SUM (DECODE (acct_item_, 2005, 0, NVL(charge,0)))
FROM acct_item
GROUP BY acc_nbr
SUM (DECODE (acct_item_, 2005, NVL(charge,0))),
SUM (DECODE (acct_item_, 2005, 0, NVL(charge,0)))
FROM acct_item
GROUP BY acc_nbr
希望大家能发挥自己的水平!