This documentation is archived and is not being maintained.

WHERE Clause (SQL Server Compact Edition)

Specifies a search condition to restrict the rows returned.


[ WHERE < search_condition >]

< search_condition >

Restricts the rows returned in the result set through the use of predicates. There is no limit to the number of predicates, separated by an AND clause, that can be included in a search condition.

The following example uses the WHERE clause to get the total number of units in stock for all discontinued products in the Products table.

SELECT SUM(UnitsInStock) AS "Units Remaining" FROM Products WHERE Discontinued = 'True'

This is the result set:

Units Remaining
---------------
101

Show: