|
锁定老帖子 主题：DB2中多个count语句合并。
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
|
|
|---|---|
| 作者 | 正文 |
|
发表时间：2014-02-12
select count(*) from db1 where grade = 1;
如何将这3条sql语句合成一条？ 在mysql中： SELECT (SELECT COUNT(*) FROM db1 WHERE gread = 1) AS g1,(SELECT COUNT(*) FROM db1WHERE gread = 2) AS g2; DB2呢？怎么实现？ 声明：ITeye文章版权属于作者，受法律保护。没有作者书面许可不得转载。
推荐链接
|
| 返回顶楼 | |
|
发表时间：2014-02-18
select sum(case when grade=1 then 1 else 0 end) as g1,
sum(case when grade=2 then 1 else 0 end) as g2, sum(case when grade=3 then 1 else 0 end) as g3 from db1 where grade in (1,2,3) |
| 返回顶楼 | |
