count内多条件查询,统计某个条件下,某列的数量,个人测试格式如下:
COUNT (id and xjzt = '1' OR NULL) AS 'ct1',
COUNT (id and xjzt = '2' OR NULL) AS 'ct2'
是对之前的补充:
https://blog.csdn.net/JAVA_nihao/article/details/98972263
仅供参考,欢迎指导。
count内多条件查询,统计某个条件下,某列的数量,个人测试格式如下:
COUNT (id and xjzt = '1' OR NULL) AS 'ct1',
COUNT (id and xjzt = '2' OR NULL) AS 'ct2'
是对之前的补充:
https://blog.csdn.net/JAVA_nihao/article/details/98972263
仅供参考,欢迎指导。