SELECT COUNT(1) FROM first_item f WHERE f.ItemStatus='10' AND f.OrgId LIKE '51%'
SELECT COUNT(1) FROM first_item f WHERE f.ItemStatus='11' AND f.OrgId LIKE '51%'
SELECT COUNT(1) FROM first_item f WHERE f.ItemStatus='12' AND f.OrgId LIKE '51%'
SELECT COUNT(1) FROM first_item f WHERE f.ItemStatus='13' AND f.OrgId LIKE '51%'
这几条数据怎么整合,用join把几条数据链接成一条数据但是没有相同的条件,怎么才能整合成一条数据
------解决思路----------------------
SELECT
SUM(CASE ItemStatus WHEN '10' THEN 1 ELSE 0 END) AS s10,
SUM(CASE ItemStatus WHEN '11' THEN 1 ELSE 0 END) AS s11,
SUM(CASE ItemStatus WHEN '12' THEN 1 ELSE 0 END) AS s12,
SUM(CASE ItemStatus WHEN '13' THEN 1 ELSE 0 END) AS s13
FROM first_item f WHERE f.OrgId LIKE '51%'