WHERE Clause (SQL Server Compact)
Specifies a search condition to restrict the rows returned.
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([Units In Stock]) AS [Units Remaining] FROM Products WHERE (Discontinued = 'True')
This is the result set:
Units Remaining --------------- 101