mysql 多个count(*)结果展示在一行
1 select 2 count(DISTINCT qid, IF(question_type = '单选题', TRUE, NULL)) as 单选题总数, 3 count(DISTINCT qid, IF(question_type = '多选题', TRUE, NULL)) as 多选题总数, 4 count(DISTINCT qid, IF(question_type = '判断题', TRUE, NULL)) as 判断题总数 5 from 6 questions
