1.查询选修了课程号为“3”的学生姓名和系别
Select sname,sdept from student where sno in (
select sno from sc where cno=‘3’);
2.查询与“刘一平”来自同一个系的学生姓名
Select sname from student where sdept in (
select sdept from student where sname=‘刘晨’) and sname <> ‘刘晨’;
3.查询Sc表中的最高分的学生学号和课程号
select sno,cno from sc where grade in(
select max(grade) from sc);
另一种:
select sno,cno from sc where grade >=all(
select grade from sc);
4.查询其它系中‘2‘号课程比信息系所有学生分数高的学生学号和姓