编辑代码

SELECT
  Exclusivity,
  COUNT(*) AS TypeCount,
  SUM(COUNT(*)) OVER () AS 总数
FROM
  masterdb.iteminfo
WHERE
  Exclusivity IN ('0111', '0110')
  AND STATUSID = 404
GROUP BY
  Exclusivity