select sum(rs) 总人数 FROM bims_sbqktjb2008 where qybm='200801' and sl>'0.00' SELECT qybm 月份,sum(sre) 总额,sum(msxmhj) 合计,sum(ynse) 小计,nvl(sum(jmse),0) 平均,sum(rs) 人数 from bims_sbqktjb2008 where ssfj is not null and ssfj='分局名称' and qybm>='200801' and qybm <='200801' group by qybm order by qybm把‘总人数’做为下个语句里的一个列怎么写 SQL语句
两个语句条件不一样的话,要么用3楼的连接
要么嵌套查询
SELECT qybm 月份,sum(sre) 总额,sum(msxmhj) 合计,sum(ynse) 小计,nvl(sum(jmse),0) 平均,sum(rs) 人数,(select sum(rs) 总人数 FROM bims_sbqktjb2008 where qybm='200801' and sl>'0.00')总人数 from bims_sbqktjb2008 where ssfj is not null and ssfj='分局名称' and qybm>='200801' and qybm <='200801' group by qybm order by qybm