WHERE Clause

Databases often contain thousands or even millions of records. In most situations, users do not want to retrieve every row from a table. Instead, they need specific information that matches certain conditions.

For example:

• A school wants students older than 18.
• A company wants employees from the IT department.
• An online store wants products costing more than ₹5000.
• A bank wants customers from a particular city.

Retrieving all records and manually searching through them would be inefficient.

To solve this problem, SQL provides the WHERE Clause.

The WHERE clause allows you to filter records and return only the rows that satisfy a specified condition. It is one of the most frequently used features in SQL because almost every real-world query requires some form of filtering.

In this lesson, you will learn how the WHERE clause works, how to apply conditions, use comparison operators, combine multiple conditions, and follow best practices for efficient querying.

What is the WHERE Clause?

The WHERE clause is used to filter records returned by a SQL query.

Instead of retrieving all rows, WHERE selects only those rows that satisfy a condition.

Example:

Result:

Students younger than or equal to 18 are excluded.

Why is the WHERE Clause Important?

Imagine a Customers table containing:

Without WHERE:

Every record is returned.

This creates:

• Large result sets
• Slower performance
• Unnecessary data processing

With WHERE:

Only relevant records are returned.

Benefits include:

• Faster queries
• Better performance
• Reduced network traffic
• Easier analysis

Basic WHERE Syntax

The general syntax is:

Example:

The condition determines which rows are returned.

Understanding the Syntax

Example:

SELECT

Specifies which data to retrieve.

FROM

Specifies the source table.

WHERE

Introduces the filtering condition.

Age > 18

The condition that must be true.

Only matching rows appear in the result.

Using Equality (=)

The equals operator finds exact matches.

Example:

Result:

Only the matching row is returned.

Using Greater Than (>)

Example:

Result:

Students older than 18 are displayed.

Using Less Than (<)

Example:

Result:

Students younger than 18 are returned.

Using Greater Than or Equal To (>=)

Example:

Result:

Students aged 18 or older are returned.

Using Less Than or Equal To (<=)

Example:

Returns students whose age is 18 or less.

Using Not Equal (!=)

Example:

Result:

All students except those aged 18.

Some database systems also support:

for not equal comparisons.

Working with Text Values

WHERE can filter text data.

Example:

Result:

Only students named Rahul are returned.

Text values are enclosed in single quotes.

Working with Numbers

Example:

Result:

Products costing more than ₹5000 are displayed.

Numbers do not require quotation marks.

Working with Dates

Example:

Result:

Orders placed on January 1st, 2025 are returned.

Date formats may vary across database systems.

Using WHERE with Multiple Conditions

Real-world filtering often requires more than one condition.

Example:

Result:

Only students meeting both conditions are returned.

Combining Conditions with AND

The AND operator requires all conditions to be true.

Example:

Result:

Only IT employees earning more than ₹50,000 are returned.

Combining Conditions with OR

The OR operator requires at least one condition to be true.

Example:

Result:

Students from Delhi or Mumbai are returned.

Using Parentheses

Parentheses improve clarity when combining conditions.

Example:

This ensures the intended logic is applied.

Real-World Example

Consider an online store.

Products table:

Query:

Result:

Only expensive products are displayed.

Common Comparison Operators

These operators form the foundation of WHERE conditions.

Common Errors

Missing Quotes Around Text

Wrong:

Correct:

Using Wrong Column Names

Example:

If Salary does not exist:

Incorrect Logic

Wrong:

May produce unexpected results.

Always verify conditions carefully.

Confusing = with ==

Wrong:

Correct:

SQL uses a single equals sign.

Best Practices

Retrieve Only Necessary Data

Good:

Avoid unnecessary columns.

Use Indexed Columns

Filtering on indexed columns improves performance.

Write Clear Conditions

Example:

is easier to understand than overly complex logic.

Test Conditions

Verify results before using queries in production systems.

Use Parentheses When Needed

This improves readability and prevents logical mistakes.

Common Interview Questions

What is the purpose of the WHERE clause?

The WHERE clause filters records based on specified conditions.

Can WHERE be used with SELECT?

Yes.

It is commonly used to retrieve specific rows.

What is the difference between AND and OR?

AND requires all conditions to be true, while OR requires at least one condition to be true.

Which operator checks equality?

is used for equality comparisons.

Summary

The WHERE clause is one of the most important features in SQL because it allows users to retrieve only the data that matches specific conditions. It improves performance, reduces unnecessary data retrieval, and helps generate meaningful results.

In this lesson, you learned:

• What the WHERE clause is
• Why filtering is important
• Basic syntax
• Comparison operators
• Filtering text, numbers, and dates
• Using AND and OR
• Common mistakes
• Best practices

Understanding the WHERE clause is essential because almost every real-world SQL query requires filtering data efficiently.

Next Step

Continue to the next lesson:

ORDER BY →