先执行子查询再执行主查询
IN //判断是否在子查询内
EXISTS //true才会执行外层
ANY 满足任意一条件
ALL 满足所有条件
SELECT * FROM STUDENT WHERE ID IN(SELECT did from grade)
SELECT * FROM STUDENT WHERE ID > any(SELECT did from grade)
先执行子查询再执行主查询
IN //判断是否在子查询内
EXISTS //true才会执行外层
ANY 满足任意一条件
ALL 满足所有条件
SELECT * FROM STUDENT WHERE ID IN(SELECT did from grade)
SELECT * FROM STUDENT WHERE ID > any(SELECT did from grade)