📖
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?