共五条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语句?
解决方案 »
- 收藏 不显示删除回复显示所有回复显示星级回复显示得分回复 希望会orcle数据库的各位,帮我比较详细地讲解一下它的运行过程和原理!
- 如何查询表的字段信息
- 有没有把所有无效对象(比如存储过程等)重新编译的脚本啊???
- 列没有编制索引 是什么问题?大家帮忙看看
- 数据库导入问题,求救!
- 9i的dmp怎么导入到8.16的数据库里面去?
- 批量修改表记录,根据要修改的表的列来作为子查询(求和语句)的条件,结果速度相当慢。。不符合客户的要求。。请各位帮忙。。
- 在两台数据库服务器之间传递数据,实现共享数据的问题。(急!!!!!)
- 两个字段值比较的sql语句问题!
- 谁在导入数据时遇见过这个错误,ORA-24810: 正在尝试写入多于指定的数据
- 请教一个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