ALL, ANY and SOME Comparison Conditions in SQL
ALL, ANY and SOME Comparison Conditions in SQL ALL The ALL comparison condition is used to compare a value to a list or subquery. It must be preceded by =, !=, >, <, <=, >= and followed by a list or subquery. SQL> select * from [dbo] . [Employees] where salary > All ( select AVG ( Salary ) from [Employees] where salary > 4000 empid mgrid empname salary ----------- ----------- ------------------------- --------------------- 1 ...