ALL and ANY keywords in SQL Server

Question

I want to know what is use of ALL and ANY keywords in SQL Server. Thank you.

Jignesh Trivedi · Answer

hi ALL compares a single value against a set of data from a query.Each value from the query's results is combined with the scalar value to generate a single scalar expression. If all of the scalar expressions evaluate to true then the result of the ALL expression will be true. Otherwise the result will be false or unknown if the results of the expressions cannot be determined. SELECT * FROM Engineers WHERE NOT DeptId = ALL (SELECT DeptId FROM DeptMaster) The ANY operator provide equivalent functionality. As with the ALL operator each creates a series of scalar expressions based upon a single value a comparison operator and the results of a single-column query. The difference is that the ANY operator return true if at least one of the generated expressions evaluates as true. SELECT * FROM Engineers WHERE NOT DeptId = ANY (SELECT DeptId FROM DeptMaster) hope this will help you.

Santhosh Kumar Jayaraman · Answer

http://dinesql.blogspot.in/2010/03/sql-server-any-and-all-operators.html