sql / beginner
Snippet
Filtering Table Rows with the WHERE Clause
The WHERE clause filters rows returned by a query, evaluating conditions for each row and including only those where the condition evaluates to true.
snippet.sql
sql
1
2
3
SELECT title, priceFROM booksWHERE price < 20.00;
Breakdown
1
SELECT title, price
Chooses the 'title' and 'price' columns to display in the result set.
2
FROM books
Sets the table source to 'books'.
3
WHERE price < 20.00;
Restricts results to rows where the value in the 'price' column is strictly less than 20.00.