SQL语句---Select

发布网友发布时间：2022-04-09 20:47

共5个回答

热心网友时间：2022-04-09 22:17

select T1.name1,T1.s1-(select sum(T2.s1) from T2 where T2.name2=T1.name1) as s1 from T1
可以直接运行

热心网友时间：2022-04-09 23:35

select T1.name1,T1.a-(select sum(T2.s1) from T2 where T2.name2=T1.name1) as s1 from T1

热心网友时间：2022-04-10 01:09

select m.name1,m.s1-n.digit from t1 m
left join (select name2,sum(isnull(s1,0)) as digit from t2 group by name2) n
on m.name1=n.name2

热心网友时间：2022-04-10 03:01

select t1.name1,t1.s1-t2.s1 as cha
from t1,(select name2,sum(s1) s1 from t2 group by 1) t3
where t1.name1=t3.name2

热心网友时间：2022-04-10 05:09

select t1.name1, sum(t1.s1)-sum(t2.s1) from t1,t2 where t1.name1=t2.name2 group by t1.name1, t2.name2

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com