当前位置：首页 → 问答吧 → 怎样把这二条查询语句并成一条?

怎样把这二条查询语句并成一条?

时间：2011-11-24

来源：互联网

不用join怎样把下面二条查询语句并成一条?
select bh,count(distinct kh) bs_j
from tk_tab
where rq between '2011-09-01' and '2011-11-10' and bz='1'

select bh,count(distinct kh) bs_d
from tk_tab
where rq between '2011-09-01' and '2011-11-10' and bz='2'

输出为:bh,bs_j,bs_d

作者: sr_ljp 发布时间: 2011-11-24

洗洗睡吧.

作者: liangCK 发布时间: 2011-11-24

不好意思漏了group by bh
select bh,count(distinct kh) bs_j
from tk_tab
where rq between '2011-09-01' and '2011-11-10' and bz='1'
group by bh

select bh,count(distinct kh) bs_d
from tk_tab
where rq between '2011-09-01' and '2011-11-10' and bz='2'
group by bh

作者: sr_ljp 发布时间: 2011-11-24

SQL code

select bh,count(distinct kh) bs_j
from tk_tab
where rq between '2011-09-01' and '2011-11-10' and bz in('1','2')
group by bh

作者: fredrickhu 发布时间: 2011-11-24

fredrickhu
谢谢!
bs_j是当bz='1'的结果,而bs_d是当bz='2'的结果.所以你提供的办法可能不行.

作者: sr_ljp 发布时间: 2011-11-24

怎样把这二条查询语句并成一条?

热门阅读

热门下载