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)))