SQL中统计数据的查询语句写法
结果：
所用到的SQL语句：
- USE QCS_DB
- select * from view_buginfo
- select 产品名称, count(BUGID) as BUG总数, ISNULL(SUM(CASE when BUG状态='待DEV处理' then 1 else 0 end) ,1) as 待DEV处理,ISNULL(SUM(CASE when BUG状态='待QA确认' then 1 else 0 end) ,1) as 待QA确认, ISNULL(SUM(CASE when BUG状态='已解决' then 1 else 0 end) ,1) as 已解决,ISNULL(SUM(CASE when BUG状态='遗留以后' then 1 else 0 end) ,1) as 遗留以后,ISNULL(SUM(CASE when BUG状态='误提交' then 1 else 0 end) ,1) as 误提交 from view_buginfo group by 产品名称
转载于:https://blog.51cto.com/jizhonglee/829888