MySQL 子查询

概念

where子句中嵌套查询语句

练习

-- 查询 数据库结构的所有考试结果(学号,科目编号,成绩),并且成绩降序排列
-- 方式一：比较习惯的联接查询
select studentno,r.subjectno,score
from result as r
inner join subject as sub
on r.subjectno = sub.subjectno
where subjectname='数据库结构'
order by score desc

-- 方式二：子查询
select studentno,r.subjectno,score
from result as r
where subjectno=(
	select subjectno from subject
	where subjectname='数据库结构'
)
order by score desc