SELECT COUNT(*),0,0 FROM A
GROUP BY
UNION ALL
SELECT 0,COUNT(*),0 FROM B
GROUP BY
UNION ALL
SELECT 0,0,COUNT(*) FROM C
GROUP BY
SELECT SUM(A),SUM(B),SUM(C)
FROM (SELECT COUNT(*) A,0 B,0 C
FROM X
GROUP BY
UNION ALL
SELECT 0 A,COUNT(*) B,0 C
FROM B
GROUP BY
UNION ALL
SELECT 0 A,0 B,COUNT(*) C
FROM C
GROUP BY)
SELECT COUNT(*) A,0 B,0 C
FROM X
GROUP BY
count()
最新推荐文章于 2024-06-28 09:30:47 发布