需求有如下的界面
一次、两次、三次是同一个字段的不同值下的记录条数。
查询一个一列数据可以使用下面的SQL语句。
select
COUNT(*)
from
shuili_company a
where
a.check_number_ = 1
and
a.is_delete = 0
from shuili_company GROUP BY province_
如果想用一条SQL语句将一次两次三次的同时查出来,可以使用下面的方式:
select province_,
ifnull(
(select
COUNT(*)
from
shuili_company a
where
a.check_number_ = 1
and
a.is_delete = 0
AND
a.province_ = shuili_company.province_
)
,0) as row1,
ifnull(
(select
COUNT(*)
from
shuili_company a
where
a.check_number_ = 2
and
a.is_delete = 0
AND
a.province_ = shuili_company.province_
),0
) as row2,
ifnull((
select
COUNT(*)
from
shuili_company a
where
a.check_number_ = 3
and
a.is_delete = 0
AND
a.province_ = shuili_company.province_
),0) as row3,
ifnull((select
COUNT(*)
from
shuili_company a
where
a.sel_eval_number_ = 1
and
a.is_delete = 0
AND
a.province_ = shuili_company.province_
),0) as row4
from shuili_company GROUP BY province_