in-----------------------------属于集合的任一成员 select * from ACCOUNT where AN_INTDM in ('1959','1376')Any--------------------------字段中的内容满足一个条件就为真 输出任何(ANY/SOME)成绩高于88分的的学生…… SELECT A.SNAME,A.SSEX,B.SCORE,D.CNAME FROM STUDENT A,SCORE B,COURSE D WHERE A.SNO=B.SNO AND B.CNO=D.CNO AND B.SCORE>ANY(SELECT B.SCORE FROM SCORE B WHERE B.SCORE=88)
select * from ACCOUNT where AN_INTDM in ('1959','1376')Any--------------------------字段中的内容满足一个条件就为真
输出任何(ANY/SOME)成绩高于88分的的学生……
SELECT A.SNAME,A.SSEX,B.SCORE,D.CNAME FROM STUDENT A,SCORE B,COURSE D WHERE A.SNO=B.SNO AND B.CNO=D.CNO AND B.SCORE>ANY(SELECT B.SCORE FROM SCORE B WHERE B.SCORE=88)