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

 

posted @ 2023-05-25 09:58  AIHHUAO  阅读(166)  评论(0)    收藏  举报