mysql 使用union,使结果合并
SELECT name,SUM(value) FROM
(SELECT
cliam_unit AS `name`,
COUNT( id ) AS `value`
FROM
ky_thesis
WHERE
statistical_year = 2020
AND cliam_unit <> ""
AND STATUS = "审核通过"
AND claim_status != '不需认领'
GROUP BY
cliam_unit
UNION
SELECT
unit .
原创
2020-11-09 17:09:01 ·
463 阅读 ·
0 评论