sql语句希望按等级查出1,2,3,4各个等级的数据,如果没有该等级的数据则为0.
按等级分组查询结果
线上数据库查询:
SELECT DISTINCT
qz.alarm_grade,
IFNULL( qza.sum, 0 ) AS count
FROM
qz_ajalarm qz
LEFT JOIN ( SELECT alarm_grade, count( 1 ) AS sum FROM qz_ajalarm WHERE alarm_desc LIKE '%漏洞%' AND is_upload = 2 GROUP BY alarm_grade ) qza ON qz.alarm_grade = qza.alarm_grade
ORDER BY
qz.alarm_grade