请问这段语句有哪里有错误吗
select C_UserCorpID,
case when sum(C_CashMoney) <1000000 then '100万以下'
when sum(C_CashMoney) >=1000000 and sum(C_CashMoney) <10000000 then '100万1000万'5000万'
when sum(C_CashMoney) >=10000000 and sum(C_CashMoney) <50000000 then '1000万
when sum(C_CashMoney) >=50000000 and sum(C_CashMoney) <100000000 then '5000万~1亿元'
when sum(C_CashMoney) >=100000000 then '1亿元以上'
else ''end 'fundtotal'
from
cf_fund_cash_index_object where C_UserCorpID is not null and C_UserCorpID<>'' group by C_UserCorpID
分界线
select C_UserCorpID,
case when sum(C_CashMoney) <1000000 then '100万以下'
when sum(C_CashMoney) >=1000000 and sum(C_CashMoney) <10000000 then '100万1000万'5000万'
when sum(C_CashMoney) >=10000000 and sum(C_CashMoney) <50000000 then '1000万
when sum(C_CashMoney) >=50000000 and sum(C_CashMoney) <100000000 then '5000万~1亿元'
when sum(C_CashMoney) >=100000000 then '1亿元以上'
else ''end 'fundtotal'
from
cf_fund_cash_index_object where C_UserCorpID is not null and C_UserCorpID<>'' group by C_UserCorpID
ERROR: syntax error at or near "'fundtotal'"
LINE 7: else ''end 'fundtotal'
^
时间: 0.006s
这是显示错误的地方，在边做边学，好多搞不懂，希望可以解答一下
else ''end 'fundtotal'
这个地方的fundtotal不应该用单引号，可以用双引号、或者不要引号。
如果有用，望采纳，谢谢！