第一问答网»论坛 › 中问网 › 问答 › 求教oracle 数据库字段求和语句

求教oracle 数据库字段求和语句

11 |

5 | 2011-10-18 03:47:00 | 显示全部楼层 |阅读模式

select t.bm,
(select count(*) from a where a.zl1=1 and a.bm=t.bm group by a.bm) as zl1,
(select count(*) from a where a.zl1=2 and a.bm=t.bm group by a.bm) as zl1,
(select count(*) from b where b.bm=t.bm group by b.bm) as qtfrom a tclwyzx希望有所提示，有空到51cto,365testing进一步交流!...

使用道具举报

千问 | 2011-10-18 03:47:00 | 显示全部楼层

select t.bm,
(select count(*) from a where a.zl1=1 and a.bm=t.bm group by a.bm) as zl1,
(select count(*) from a where a.zl1=2 and a.bm=t.bm group by a.bm) as zl1,...

使用道具举报