Compares a scalar value with a single-column set of values.
scalar_expression { = | <> | != | > | >= | !> | < | <= | !< } ALL ( subquery )
Arguments
scalar_expression
Any valid expression in SQL Server Compact 3.5.{ = | <> | != | > | >= | !> | < | <= | !< }
The comparison operator.subquery
A subquery that returns a result set of one column. The data type of the returned column must be the same data type as the data type of scalar_expression.A subquery is a restricted SELECT statement. The ORDER BY clause, the COMPUTE clause, and the INTO keyword are not permitted.
bit
Returns TRUE when the comparison specified is TRUE for all pairs (scalar_expression, x) where x is a value in the single-column set. Otherwise, returns FALSE.
Example
The following example returns a list.of employees that are not in the specified table.
SELECT * FROM Employees WHERE ([Employee ID] <> ALL (SELECT [Employee ID] FROM Employees AS Employees_1 WHERE ([Employee ID] < 10)))