在一个有10个表的数据库中,我想根据日期范围对表T2、T3、T4、T5、T7的行( count (*))进行查询。就像不。上次加载的记录,在日期范围内加载,并输出put为。例如:

发布于 2020-03-10 09:45:57
你可以UNION几个查询的结果,例如:
SELECT 'T2' as TableName, COUNT(*), MAX(DATE) FROM t2
UNION ALL
SELECT 'T3' as TableName, COUNT(*), MAX(DATE) FROM t3
UNION ALL
SELECT 'T4' as TableName, COUNT(*), MAX(DATE) FROM t4
UNION ALL
SELECT 'T5' as TableName, COUNT(*), MAX(DATE) FROM t5
UNION ALL
SELECT 'T7' as TableName, COUNT(*), MAX(DATE) FROM t7https://stackoverflow.com/questions/60601844
复制相似问题