.png)
SQL Server 2008 R2
Compares a scalar value with a single-column set of values.
ONE can be used with the SOME or ANY arguments.
-- This example queries for Employee ID values greater than 13.
-- The query locates some matching values,
-- a result of True is returned, with a list of the
-- matching Employee records.
SELECT *
FROM Employees
WHERE (0 < ANY
(SELECT [Employee ID]
FROM Employees AS Employees_1
WHERE ([Employee ID] > 13)));
-- This example queries for Employee ID values greater than 15.
-- Because no matching values are found, a result of False is
-- returned and no records are displayed.
SELECT *
FROM Employees
WHERE (0 < ANY
(SELECT [Employee ID]
FROM Employees AS Employees_1
WHERE ([Employee ID] > 15)));
