mysql----exists子查询

最新推荐文章于 2021-02-07 08:41:39 发布

sanjiaowuhuan

最新推荐文章于 2021-02-07 08:41:39 发布

阅读量157

点赞数

本文链接：https://blog.csdn.net/sanjiaowuhuan/article/details/99842572

版权

teacher-note 专栏收录该内容

97 篇文章 0 订阅

订阅专栏

SELECT * FROM student WHERE studentno IN (SELECT studentno FROM result)
SELECT * FROM student WHERE studentno NOT IN (SELECT studentno FROM result)
SELECT * FROM student WHERE studentno = 1000
#先遍历父查询的行，在遍历过程中执行子查询
SELECT studentno,studentresult FROM result 
WHERE EXISTS(SELECT * FROM result WHERE studentresult>10)
ORDER BY studentresult DESC
LIMIT 5

#有学生的年级信息
SELECT * FROM grade WHERE gradeid IN (SELECT gradeid FROM student)
# 关联子查询
SELECT * FROM grade WHERE EXISTS (SELECT * FROM student WHERE gradeid=grade.`gradeID`)
#没有学生的年级信息
SELECT * FROM grade WHERE NOT EXISTS (SELECT * FROM student WHERE gradeid=grade.`gradeID`)