同时返回几个表的记录个数 可否用一条sql实现同时返回几个表的记录个数比如表A,表Bselect count(*) from Aselect count(*) from B怎样合在一起显示? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select (select count(*) from A)+(select count(*) from B) select count(*) from Aunion allselect count(*) from B select count(*) from AUNION ALLselect count(*) from B SELECT *FROM (SELECT 'A' AS tbname,COUNT(*) AS rowcnt FROM A) AS A, (SELECT 'B' AS tbname,COUNT(*) AS rowcnt FROM B) AS B UNION ALLUNION ALLUNION ALLUNION ALL SQL2008压缩日志文件 求一个查询语句 新手求个MSSQL数据库索引代码,在线等。。。 谁来帮我加个引号? 求一触发器写法,请大家帮忙! 如何按将一个表的时间的记录放到另一个表中 数据查询问题 向临时表插入数据出错 多项选择题经果统计问题,sql语句怎么写? 向大力兄单独提的问题; 字段内容大小写问题 请问数据表里的字段名带个#是什么意思
union all
select count(*) from B
UNION ALL
select count(*) from B
FROM (SELECT 'A' AS tbname,COUNT(*) AS rowcnt FROM A) AS A,
(SELECT 'B' AS tbname,COUNT(*) AS rowcnt FROM B) AS B
UNION ALL
UNION ALL
UNION ALL