Filtering with WHERE

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

sql

SELECT *
FROM products
WHERE price > 100;

Breakdown

SELECT *

Selects all columns from the table.

WHERE price > 100;

A condition that filters rows where the price value is greater than 100.

Previous snippet Next snippet

More Beginner SQL exercises →

From your library

Filtering with WHERE

Related