select a课程名,bnum as 人数 from 课程 as a,(select 课程号,count()num from 选课 group by 课程号 having count()>3) as b where a课程号=b课程号
select acnum,acname,ars,bbjg_rs
from
(select seccnum,ccname,count(ssnum) as 'rs'
from student s,course c,sc,sections sec
where ssnum = scsnum and
scsecnum = secsecnum and
seccnum = ccnum
group by seccnum,ccname) a
left join
(select seccnum,ccname,count(ssnum) as 'bjg_rs'
from student s,course c,sc,sections sec
where ssnum = scsnum and
scsecnum = secsecnum and
seccnum = ccnum and
scscore < '60'
group by seccnum,ccname) b
on acnum = bcnum
Select Count(学生学号)
From 表
Update 表 Set 成绩+10
Where 选修课程号 = 3
Select 学号,姓名,年龄
From 表
Where 姓名 Like '_仁%'
Select 学号,姓名,成绩
From 表
Where 选修课='DB'
And 成绩>90
Order 成绩 desc
--下次提问麻烦给表可以吗
ORDER BY 2,是你在用SELECT作查询时,用第二个字段进行排序,
例如 select name,age from 表 order by 2,(指按age字段排序)
select name,age,score from 表 order by 3(指按score字段排序)
select from course where cno in
(select top 1 cno from sc group by cno order by count() desc)
后边括号里,是选出选课人数最多的那门课程编号,外边一个嵌套选出这门课程的具体信息
以上就是关于sql 2008查询至少有4个同学选修的课程名和人数全部的内容,包括:sql 2008查询至少有4个同学选修的课程名和人数、SQL查询 统计每门课的选课人数及不及格人数、SQL语句编写问题统计选课的学生人数; 将选修课程号为3的学生成绩加10分等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)