Where Filters

Where Status Equals

An equality predicate keeps rows with the requested category value.

highlighted = computed this step

Input table

Use the same Orders table with repeated status values.

Orders\text{Orders}
Ordersorder_idstatusamounto1paid120o2pending40o3paid70o4review95

Where query

Filter to rows whose status equals the requested label.

WHERE status equals paid\text{WHERE status equals paid}
WHERE status equals paidwhere status eq paidarity 3 rows 2Ordersarity 3 rows 4

Filtered output

Both matching paid rows remain because WHERE does not dedupe.

paid orders\text{paid orders}
Filtered outputorder_idstatusamounto1paid120o3paid70