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

EXISTS (SQL Server Compact)

Updated: 5 December 2005

Specifies a subquery to test for the existence of rows.


EXISTS subquery
subquery

A restricted SELECT statement.

Returns TRUE if a subquery contains any rows.

The following example finds all orders in the Orders table, with "Washington" as the Shipping Region, for each employee listed in the Employees table.

SELECT * FROM Orders WHERE [Ship Region] = 'WA' AND EXISTS (SELECT [Employee ID] FROM Employees AS Emp WHERE Emp.[Employee ID] = Orders.[Employee ID])

Release

History

5 December 2005

Changed content

Updated code

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.