sql一个表中同时查询两个count的sql语句

可以有两种解决方法。 方法1： SELECT paperName , COUNT (1) AS 总题数 , sum (CASE WHEN statu = 1 THEN 1 ELSE 0 END) AS 审核题数 FROM question GROUP BY paperNme 方法2： select s.总题数, s.审核题数, s.paperName from ( select COUNT(1) as 总题数, case when status = 1 then count(1) else 0 end