17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT ID, DECODE(CLASS, '西药', '13', CLASS), SUM(COST), SUM(CHARGE)
FROM TAB
GROUP BY ID, DECODE(CLASS, '西药', '13', CLASS)
[/quote]
update 更新怎么办??因为id 的值不只一个。。。[/quote]
UPDATE TAB
SET (TAB.COST, TAB.CHARGE) = (SELECT SUM(COST), SUM(CHARGE)
FROM TAB T
WHERE T.ID = TAB.ID
AND DECODE(T.CLASS, '西药', '13', T.CLASS) =
TAB.CLASS)
你自己测试一下吧哈
SELECT ID, DECODE(CLASS, '西药', '13', CLASS), SUM(COST), SUM(CHARGE)
FROM TAB
GROUP BY ID, DECODE(CLASS, '西药', '13', CLASS)
[/quote]
update 更新怎么办??因为id 的值不只一个。。。SELECT ID, DECODE(CLASS, '西药', '13', CLASS), SUM(COST), SUM(CHARGE)
FROM TAB
GROUP BY ID, DECODE(CLASS, '西药', '13', CLASS)