SQL一次性查询一个字段不同条件下的统计结果
SQL一次性查询一个字段不同条件下的统计结果
参考了一下这篇文章:https://blog.csdn.net/xichenguan/article/details/51764100 , 感谢原作者
一次、两次、三次是同一个字段的不同值下的记录条数。
查询一个一列数据可以使用下面的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_,
isnull((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,
isnull((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,
isnull((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,
isnull((