六、子查询——简单子查询
1.何为简单子查询
子查询结果为一个值,主查询与子查询之间进行比较使用<,>,=,>=,<=,<>等运算符。
2.简单子查询实例
(1)示例1
找出成绩比宋刚高的所有同学的成绩。
<1>找到宋刚同学的成绩
select score from student_score where name='宋刚';
<2>选择成绩高于宋刚的同学的所有信息
select * from student_score where score>65;
<3>总的SQL语句为:
select * from student_score
where score>(select score from student_score where name='宋刚');
(2)示例2
找出成绩高于宋刚的并且学号低于宋刚的人。
<1>找出宋刚的成绩。
select score from student_score where name='宋刚';
<2>找出宋刚的学号。
select student_id from student_score where name='宋刚';
<3>找出成绩高于宋刚的并且学号低于宋刚的人。
select * from student_score where score>65 and student_id<10032010111;
<4>总的SQL语句为:
select * from student_score
where score>(select score from student_score where name='宋刚')
and
student_id<(select student_id from student_score where name='宋刚');
3.关键点
简单子查询结果只能返回单个值。
解锁课程,学习更多mysql知识:
https://study.163.com/course/courseMain.htm?courseId=1209590958&share=2&shareId=400000000537035