12 · Databases & SQL
WHERE
Filter to matching rows
The clause that narrows a query down to only the rows meeting a condition.
Concrete example
Adding “WHERE price is over 100” returns only the expensive items.
Filter to matching rows
The clause that narrows a query down to only the rows meeting a condition.
Adding “WHERE price is over 100” returns only the expensive items.