高分求助:一个棘手的sql语句 select b.sno2,sum(a.count)from table1 ajoin table2 b on a.sno = b.sno1group by b.sno2 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select b.sno2,sum(count) as countfrom table1 as a inner join table2 as b on a.sno=b.sno1group by b.sno2order by b.sno2 select b.sno2,sum(a.count) as 总和from table1 ajoin table2 b on a.sno = b.sno1group by b.sno2 select b.sno2,sum(a.count) from table2 as b left outer join table1 as a on b.sno1 = a.sno group by b.sno2 select b.sno2,sum(a.count)from table1 ajoin table2 b on a.sno = b.sno1group by b.sno2 jsp个人博客怎么建表 能够这样输出吗?100分 求助一个SQL语句统计任意一个区间段信息. 新技术问题 如何得到字段的位置号呢? isql工具在那里?主要的功能是什么? 注册 这种序号怎么排序,1.2 1.3 11.5 11.5.2 12.6 12.6.1 13 9.8 2.5 自动编号的记录,AddNew后,回读新加记录,得不到这个自动编号的字段值? asp 和 sql server 的问题? 如何实现这种查询 这个SQL语句如何写?面试遇到的题目!
from table1 as a
inner join table2 as b on a.sno=b.sno1
group by b.sno2
order by b.sno2
from table1 a
join table2 b on a.sno = b.sno1
group by b.sno2
from table1 a
join table2 b on a.sno = b.sno1
group by b.sno2