Export (0) Print
Expand All
Expand Minimize
3 out of 5 rated this helpful - Rate this topic

ALL (SQL Server Compact)

Compares a scalar value with a single-column set of values.


scalar_expression { = | <> | != | > | >= | !> | < | <= | !< } ALL ( subquery )
scalar_expression

Any valid expression in SQL Server Compact.

{ = | <> | != | > | >= | !> | < | <= | !< }

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.

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.

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)))
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.