Home›Learn›SQL›WHERE Clause
SQL Master CourseBeginner Friendly

WHERE Clause

Learn how to filter rows using the WHERE clause.

📘 Chapter 8 / 51⏱️ 8–10 Min Read🎯 Beginner Friendly
Course Progress16%

Course Progress

16%

8 / 51 chapters

📖

Theory

Understand the concept step by step

The WHERE clause is used to filter records based on a condition. Only rows that satisfy the condition are returned or affected. WHERE can be used with SELECT, UPDATE and DELETE.
💻

Example

See how the concept works in SQL

SQL
SELECT *
FROM users
WHERE age > 18;
📤

Output

Understand what the query produces

The query returns users whose age is greater than 18.

📝

Practice

Test your understanding

Find all employees whose salary is greater than 50000.

❓

MCQs

Check your SQL knowledge

What is the main concept covered in WHERE Clause?

A.Filters rows
B.Creates databases
C.Deletes tables
D.Creates indexes
💼

Interview Questions

Prepare for SQL interviews

1

Interview Question

What is the WHERE clause?

2

Interview Question

Can WHERE be used with UPDATE?

3

Interview Question

Can WHERE be used with DELETE?