Predicate | Description |
---|---|
SELECT * FROM Employee WHERE Salary < 40000; |
Predicate in a WHERE clause specifying a condition for selecting rows from the Employee table. |
SELECT SUM(CASE WHEN part BETWEEN 100 AND 199 THEN 0 ELSE cost END) FROM Orders; |
Predicate in a CASE expression specifying a condition that determines the value passed to the SUM function for a particular row in the Orders table. |