想到以下SQL语句转化成能在ACCESS2003下运行的语句,谢谢
select [第一题答对个数]=sum(case [第一题答案] when 'a' then 1 else 0 end)
,[第二题答对个数]=sum(case [第二题答案] when 'b' then 1 else 0 end)
,[第三题答对个数]=sum(case [第三题答案] when 'c' then 1 else 0 end)
from tbselect *,[答对个数]=case [第一题答案] when 'a' then 1 else 0 end
+case [第二题答案] when 'b' then 1 else 0 end
+case [第三题答案] when 'c' then 1 else 0 end
from tb
select [第一题答对个数]=sum(case [第一题答案] when 'a' then 1 else 0 end)
,[第二题答对个数]=sum(case [第二题答案] when 'b' then 1 else 0 end)
,[第三题答对个数]=sum(case [第三题答案] when 'c' then 1 else 0 end)
from tbselect *,[答对个数]=case [第一题答案] when 'a' then 1 else 0 end
+case [第二题答案] when 'b' then 1 else 0 end
+case [第三题答案] when 'c' then 1 else 0 end
from tb
--try
select *,[答对个数]=IIF([第一题答案]='a', 1 ,0)
+IIF([第二题答案]='b', 1, 0)
+IIF([第三题答案]='c', 1, 0)
from tb