sql

最新推荐文章于 2024-09-21 10:03:28 发布

j249976177

最新推荐文章于 2024-09-21 10:03:28 发布

阅读量406

点赞数

本文链接：https://blog.youkuaiyun.com/j249976177/article/details/20014619

版权

(select c.class ,'A'as type,
(select count(name) from t_user a where a.class=c.class)num1 ,
(select count(name) from b_user a where a.class=c.class)num2
from (select distinct class from t_user b)c
union
select '总计','A',
(select count(name) from t_user where class in (select distinct class from t_user b)),
(select count(name) from b_user where class in (select distinct class from t_user b))
from dual)
union
(select c.class ,'B'as type,
(select count(name) from t_user a where a.class=c.class)num1 ,
(select count(name) from b_user a where a.class=c.class)num2
from (select distinct class from t_user b)c
union
select '总计','B',
(select count(name) from t_user where class in (select distinct class from t_user b)),
(select count(name) from b_user where class in (select distinct class from t_user b))
from dual)
order by type