相乘应该为15
方法①
select aaaa.res1 * bbbb.res2 as x
from (select count(*) res1 from test)aaaa,
(select count(*) res2 from test2)bbbb
方法②
select (select count(*) from test)*(select count(*) from test2) as x
作者:鲨鱼辣椒灬
来源:CSDN
相乘应该为15
方法①
select aaaa.res1 * bbbb.res2 as x
from (select count(*) res1 from test)aaaa,
(select count(*) res2 from test2)bbbb
方法②
select (select count(*) from test)*(select count(*) from test2) as x
作者:鲨鱼辣椒灬
来源:CSDN