数据库sql server 2008 中ANY关键字的意思

【专家解说】：您好，any是这个意思:达式只要与子查询结果集中的某个值满足比较的关系时，就返回true,否则返回false。 带any嵌套查询 select emp.empno,emp.ename,emp.sal from scott.emp where sal>any(select sal from scott.emp where job='manager'); 等价于 select sal from scott.emp where job='manager' 结果为 sal:2975 2850 2450 select emp.empno,emp.ename,emp.sal from scott.emp where sal>2975 or sal>2850 or sal>2450