数据库查询

连接查询与子查询

列题：

1. 谁和刘晨同岁

select sage
from student
where sage = (select sage
from student
where sname=“刘晨”)
and sname <>’刘晨’;

2. 查询各个学生的姓名、所选修课程号及成绩。

select sname,cno,grade
from student join sc on student.sno=sc.sno；

3. 查询刘晨选修了几门课程。(两种方法)

select count(cno)
from sc join student on student.sno=sc.sno
where sname=“刘晨”;
select count(cno)
from sc
where sno=(select sno
from student
where sname=“刘晨”);

4. 查询选修了1号课或2号课的学生的姓名。(两种方法)

Select(distinct(去掉重复)) sname,cno
from student join sc on student.sno=sc.sno
where cno=“c01” or cno=“c02”;
select sname
from student
where sno in(select sno
from sc
where cno = ‘c01’ or cno = ‘c02’);