any 、all

 

any是任意一个，只有满足一个条件即可

all是全部，必须满足全部条件

查询选修编号为“3-105“课程且成绩至少高于选修编号为“3-245”的同学的Cno、Sno和Degree,并按Degree从高到低次序排序。
select * from score where  cno = '3-105' and degree>any(select degree from score where Cno = '3-245' ) order by DEGREE desc
查询选修编号为“3-105”且成绩高于选修编号为“3-245”课程的同学的Cno、Sno和Degree.
select * from score where  cno = '3-105' and degree>all(select degree from score where Cno = '3-245' )