sql / beginner
Snippet
Filtering with WHERE
The WHERE clause is used to filter records. It ensures that only rows meeting a specific condition—in this case, products with a price greater than 100—are returned.
snippet.sql
1
2
3
SELECT *FROM productsWHERE price > 100;
Breakdown
1
SELECT *
Selects all columns from the table.
2
WHERE price > 100;
A condition that filters rows where the price value is greater than 100.