- 从student表中检索学生所在班级编码,并消除重复行
select distinct classno
from student
- 检索课程表(course)中的教师名、课程号、课程名称,要求检索结果按照教师名降序排序
select Teacher,CouNo,CouName
from Course
order by teacher desc
- 检索课程表(course)信息,显示课程号大于’005’的课程编号及课程名称,只显示结果中前15行
select top 15 couno as'课程号',couname as '课程名'
from course
where couno>005
- 检索每位教师所上课程的平均报名人数,只显示平均报名人数在25到35人之间的教师
select Teacher,avg(willnum)
from course
group by teacher
having avg(willnum)>25