假设我有两个sql
1、select count(1) from A; 结果100
2、select count(1) from B; 结果200我怎么用一个sql把这两个结果同时得到:count(1) count(1)
100 200感谢~~~~
1、select count(1) from A; 结果100
2、select count(1) from B; 结果200我怎么用一个sql把这两个结果同时得到:count(1) count(1)
100 200感谢~~~~
调试欢乐多
(select count(1) from A) AS totA,
(select count(1) from B) AS totB
FROM dual;