共五条SQL语句,
是查 第一项(catscore),分数(catscore)为1的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='1' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为2的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='2' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为3的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='3' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为4的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='4' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为5的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='5' and catid='01' and role='1' and userID in (119,137,112) group by catid
怎么把这五条SQL语句合并成一条SQL语句?
是查 第一项(catscore),分数(catscore)为1的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='1' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为2的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='2' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为3的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='3' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为4的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='4' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为5的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='5' and catid='01' and role='1' and userID in (119,137,112) group by catid
怎么把这五条SQL语句合并成一条SQL语句?
解决方案 »
- oracle手工建库步骤
- 字符集为AL32UTF8的数据库数据可否导入到字符集为ZHS16GBK的数据库
- 執行超長的SQL語句報錯:ORA-00600:內部錯誤代碼,參數:[733],[33803732],[top call heap],[],[],[],[],[]
- oracle存储过程 统计同列的不同值
- export query results问题
- [求助] 求一个效率高的SQL
- 数据转换问题!
- 请问,w2000加oracle8.04中OracleTNSListener80服务无法启动,如何解决???
- 如何使Windows2000中的Oracle 8.1.6的ManagementServer服务在启动操作系统后自动启动;
- N多个号码如何存储和查询?
- 请教一个Oracle中的触发器语句!
- 请教一个oracle生产环境下监听的问题!
SUM(DECODE(catscore,'1',1,0)) AS 分数 为1的投票数,
SUM(DECODE(catscore,'2',1,0)) AS 分数 为2的投票数,
SUM(DECODE(catscore,'3',1,0)) AS 分数 为3的投票数,
SUM(DECODE(catscore,'4',1,0)) AS 分数 为4的投票数,
SUM(DECODE(catscore,'5',1,0)) AS 分数 为5的投票数
FROM trainingMarkRecord
WHERE trainingid=60
AND catid='01' and role='1' and userID in (119,137,112)
group by catid
是查 第一项(catscore),分数(catscore)为1的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='1' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为2的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='2' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为3的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='3' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为4的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='4' and catid='01' and role='1' and userID in (119,137,112) group by catid
是查 第一项(catscore),分数(catscore)为5的投票数,
select count(*) total from trainingMarkRecord where trainingid=603 and catscore='5' and catid='01' and role='1' and userID in (119,137,112) group by catid是查 第二项(catscore),分数(catscore)为1的投票数,
select count(*) total from trainingMarkRecord where trainingid=604 and catscore='1' and catid='02' and role='1' and userID in (177) group by catid
是查 第二项(catscore),分数(catscore)为2的投票数,
select count(*) total from trainingMarkRecord where trainingid=604 and catscore='2' and catid='02' and role='1' and userID in (177) group by catid
是查 第二项(catscore),分数(catscore)为3的投票数,
select count(*) total from trainingMarkRecord where trainingid=604 and catscore='3' and catid='02' and role='1' and userID in (177) group by catid
是查 第二项(catscore),分数(catscore)为4的投票数,
select count(*) total from trainingMarkRecord where trainingid=604 and catscore='4' and catid='02' and role='1' and userID in (177) group by catid
是查 第二项(catscore),分数(catscore)为5的投票数,
select count(*) total from trainingMarkRecord where trainingid=604 and catscore='5' and catid='02' and role='1' and userID in (177) group by catid怎么把这五条SQL语句合并成一条SQL语句?
SUM(DECODE(catscore,'1',1,0)) AS score1,
SUM(DECODE(catscore,'2',1,0)) AS score2,
SUM(DECODE(catscore,'3',1,0)) AS score3,
SUM(DECODE(catscore,'4',1,0)) AS score4,
SUM(DECODE(catscore,'5',1,0)) AS score5
FROM trainingMarkRecord
WHERE trainingid=60
AND catid='01' and role='1' and userID in (xx,xx,xx...)
group by trainingid,catid