SQL Filter results using WHERE and HAVING The WHERE clause only returns rows that match its criteria
Example
Steam has a games under $10 section of their store page. Somewhere deep in the heart of their systems, there's probably a query that looks something like:
SELECT *
FROM Items
WHERE Price < 10
