7,388
社区成员
发帖
与我相关
我的任务
分享
SELECT 日期, 'a' AS 表名 , COUNT(*) AS 行数 FROM a WHERE 日期 = CAST('20180101' AS DATE)GROUP BY 日期
UNION ALL
SELECT 日期, 'b' AS 表名 , COUNT(*) AS 行数 FROM b WHERE 日期 = CAST('20180101' AS DATE)GROUP BY 日期
UNION ALL
SELECT 日期, 'c' AS 表名 , COUNT(*) AS 行数 FROM c WHERE 日期 = CAST('20180101' AS DATE)GROUP BY 日期
UNION ALL
SELECT 日期, 'd' AS 表名 , COUNT(*) AS 行数 FROM d WHERE 日期 = CAST('20180101' AS DATE)GROUP BY 日期
UNION ALL
SELECT 日期, 'e' AS 表名 , COUNT(*) AS 行数 FROM e WHERE 日期 = CAST('20180101' AS DATE)GROUP BY 日期
UNION ALL
SELECT 日期, 'f' AS 表名 , COUNT(*) AS 行数 FROM f WHERE 日期 = CAST('20180101' AS DATE)GROUP BY 日期
UNION ALL
SELECT 日期, 'g' AS 表名 , COUNT(*) AS 行数 FROM g WHERE 日期 = CAST('20180101' AS DATE)GROUP BY 日期
UNION ALL
SELECT 日期, 'h' AS 表名 , COUNT(*) AS 行数 FROM h WHERE 日期 = CAST('20180101' AS DATE)GROUP BY 日期
UNION ALL
SELECT 日期, 'i' AS 表名 , COUNT(*) AS 行数 FROM h WHERE 日期 = CAST('20180101' AS DATE)GROUP BY 日期