Essential Books

The WHERE clause only returns rows that match its criteria

suggest change

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
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Filter results using WHERE and HAVING:
* Filter results using WHERE and HAVING
* Use BETWEEN to Filter Results
* Use HAVING with Aggregate Functions
* WHERE clause with NULLNOT NULL values
* The WHERE clause only returns rows that match its criteria
* Equality
* AND and OR
* Use IN to return rows with a value contained in a list
* Use LIKE to find matching strings and substrings
* Use HAVING to check for multiple conditions in a group
* Where EXISTS
Table Of Contents