數(shù)據(jù)庫sql server 2008 中ANY關(guān)鍵字的意思

【專家解說】：您好，any是這個意思:達(dá)式只要與子查詢結(jié)果集中的某個值滿足比較的關(guān)系時，就返回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' 結(jié)果為 sal:2975 2850 2450 select emp.empno,emp.ename,emp.sal from scott.emp where sal>2975 or sal>2850 or sal>2450