--LZ已经帮你回答了,4个select的括号后加入","或其他运算符,如果改成其他简单的写法,这样写 select count(decode(F_Key,'5',1,null))*10 +count(decode(F_Key,'4',1,null))*9 +count(decode(F_Key,'3',1,null))*6 +count(decode(F_Key,'2',1,null))*3 as Molecule from C where F_AS in (6334904174790331938) and to_char(F_In,'yyyy-mm-dd')='2012-06-27';
and F_AS in (6334904174790331938)这句有问题
--LZ已经帮你回答了,4个select的括号后加入","或其他运算符,如果改成其他简单的写法,这样写
select count(decode(F_Key,'5',1,null))*10
+count(decode(F_Key,'4',1,null))*9
+count(decode(F_Key,'3',1,null))*6
+count(decode(F_Key,'2',1,null))*3
as Molecule
from C
where F_AS in (6334904174790331938) and to_char(F_In,'yyyy-mm-dd')='2012-06-27';