提示missing right parenthesis,缺少右括号

[llhh]

提示missing right parenthesis,缺少右括号，这个句子有什么问题？
select viewno,sum(case CARRYDATE when '2006-03-16' then SUM1 else 0 end) 2006-03-16
from SENDMATVIEW GROUP BY viewno

[宾子寻月人]

可以用decode函数啊.

[chanet]

try it:

SELECT VIEWNO,
SUM(CASE CARRYDATE
WHEN '2006-03-16' THEN SUM1
ELSE 0
END) '2006-03-16'
FROM SENDMATVIEW
GROUP BY VIEWNO