Where Filters

Where And Or Filters

Logical operators combine smaller WHERE predicates into one row filter.

highlighted = computed this step

Input table

Start with orders that include status and amount.

Orders\text{Orders}
Ordersorder_idstatusamounto1paid120o2pending40o3paid70o4review95

Where query

Keep paid high-amount rows, or rows that need review.

WHERE combined predicates\text{WHERE combined predicates}
WHERE combined predicateswhere orarity 3 rows 2Ordersarity 3 rows 4

Filtered output

The combined predicate keeps one paid order and one review order.

combined filter output\text{combined filter output}
Filtered outputorder_idstatusamounto1paid120o4review95