分组依据中的案例陈述

Question

获取此错误ORA-12704:字符集不匹配

SELECT name,
YEAR,
PERIOD,
ENTITY,
CASE WHEN VALUE = 'USD Total' then 'USD' ELSE VALUE end as VALUE,
sum(amount)
from stats1
group by
name,
YEAR,
PERIOD,
ENTITY,
CASE WHEN VALUE = 'USD Total' then 'USD' ELSE VALUE end,
''''

Answer 1

SELECT
name                                                            ,
YEAR                                                            ,
PERIOD                                                          ,
ENTITY                                                          ,
CASE WHEN VALUE = 'USD Total' THEN 'USD' ELSE VALUE END AS VALUE,
SUM(amount)
FROM
stats1
GROUP BY
name  ,
YEAR  ,
PERIOD,
ENTITY,
VALUE

Answer 2

下面的代码正在工作，但为什么它不接受其他部分。。。。如果值不是"美元总额"，我想按原样传递值

SELECT name,
YEAR,
PERIOD,
ENTITY,
CASE WHEN VALUE = 'USD Total' then 'USD' end as VALUE,
sum(amount)
from stats1
group by
name,
YEAR,
PERIOD,
ENTITY,
CASE WHEN VALUE = 'USD Total' then 'USD' end