select ClassID, count(*) as '学生人数', sum(奖惩总数) as '奖惩总数'
from
(
select B.ClassID,B.UserID,D.奖惩总数
from B
left join
(
select UserID ,count(*) as '奖惩总数'
from C
group by UserID
) D
on B.UserID = D.UserID
) E
group by ClassID
解决方案 »
- 将字符串以‘|’分割,然后根据分割的内容进行模糊查询
- 不可以用服务器名\实例名的形式连接SQLSERVER2005
- 为什么会显示 Could not find the main class,program will exit.???
- 关于索引的问题
- SQL语句弱弱的问2
- 如何消除重复记录(用distinct不可以)
- 请各位大侠帮忙,关于分组查询的超难问题,先谢了
- MSDE2000安装问题---在线等待。。。。。。。。。。。。____。。。。^-^ 。。。
- 用ADO访问数据库通常要在connectionstring里写上user和pwd,默认是sa,密码没有,如果目标机的用户名密码有变化怎么实现?
- 紧急求救!!最后30分全给了
- 大量数据批量入库得问题请教
- SOS:如何得到SQL7.0或2000的ServicePack版本情况?
from A
left join
(select ClassID, count(*) as '学生人数', sum(奖惩总数) as '奖惩总数'
from
(
select B.ClassID,B.UserID,D.奖惩总数
from B
left join
(
select UserID ,count(*) as '奖惩总数'
from C
group by UserID
) D
on B.UserID = D.UserID
) E
group by ClassID
) F
on A.ClassID = F.ClassID
from 表A a 表B b,表C c where a.classID=b.classID and c.userID=b.classID
group by a.classID,a.classname
group by a.classID,a.classname
from A
left join
(select ClassID, count(*) as '学生人数', sum(奖惩总数) as '奖惩总数'
from
(
select B.ClassID,B.UserID,D.奖惩总数
from B
left join
(
select UserID ,count(*) as '奖惩总数'
from C
group by UserID
) D
on B.UserID = D.UserID
) E
group by ClassID
) F
on A.ClassID = F.ClassID