Filtering Data

Filtering Data

Filtering Data is one of the most powerful and frequently used SQL skills in Data Analytics. After retrieving information using the SELECT Statement, Data Analysts often need only specific records rather than entire datasets. Filtering Data allows users to narrow down results based on conditions, making reports more meaningful and efficient.

Organizations store millions of records in databases. A sales database may contain years of transaction history, a customer database may contain millions of users, and an HR system may contain thousands of employee records. Without Filtering Data, analysts would struggle to find relevant information quickly.

Businesses use Filtering Data to:

• Find specific customers.
• Analyze regional sales.
• Track employee performance.
• Monitor financial transactions.
• Build dashboards.
• Generate reports.
• Support decision-making.

Mastering Filtering Data is essential for Data Analysts, Business Analysts, Database Administrators, and Business Intelligence professionals.

What is Filtering Data?

Filtering Data is the process of retrieving only those records that meet specific conditions.

Instead of displaying all records, SQL returns only the rows that satisfy the specified criteria.

Example:

A customer table contains 10,000 records.

Management wants customers from Jaipur only.

Filtering Data allows SQL to retrieve only those relevant records.

Benefits:

• Faster analysis.
• Better reporting.
• Improved decision-making.

The WHERE Clause

The WHERE clause is the primary tool used for Filtering Data.

Basic Syntax

SELECT column_name
FROM table_name
WHERE condition;

The WHERE clause tells SQL which records should be included in the result.

Example: Filtering Customers by City

Table:

Query:

SELECT *
FROM Customers
WHERE City = 'Jaipur';

Result:

Only customers from Jaipur are returned.

Comparison Operators in Filtering Data

SQL uses comparison operators for filtering.

Equal To (=)

Example:

SELECT *
FROM Employees
WHERE Department = 'HR';

Returns only HR employees.

Not Equal To (!=)

Example:

SELECT *
FROM Employees
WHERE Department != 'HR';

Returns all employees except HR employees.

Greater Than (>)

Example:

SELECT *
FROM Sales
WHERE Revenue > 50000;

Returns sales records above ₹50,000.

Less Than (<)

Example:

SELECT *
FROM Sales
WHERE Revenue < 50000;

Returns sales records below ₹50,000.

Greater Than or Equal To (>=)

Example:

SELECT *
FROM Sales
WHERE Revenue >= 50000;

Returns records equal to or greater than ₹50,000.

Less Than or Equal To (<=)

Example:

SELECT *
FROM Sales
WHERE Revenue <= 50000;

Returns records equal to or below ₹50,000.

Filtering Numeric Data

Numeric filtering is common in business reporting.

Example:

SELECT ProductName,
       Revenue
FROM Sales
WHERE Revenue > 100000;

Applications:

• High-value transactions.
• Revenue analysis.
• KPI reporting.

Filtering Text Data

Example:

SELECT CustomerName
FROM Customers
WHERE City = 'Delhi';

Applications:

• Customer segmentation.
• Geographic reporting.

Filtering Date Data

Example:

SELECT *
FROM Orders
WHERE OrderDate = '2026-06-01';

Applications:

• Daily sales reports.
• Attendance tracking.
• Transaction monitoring.

Using AND Operator

AND combines multiple conditions.

Syntax

SELECT *
FROM table_name
WHERE condition1
AND condition2;

Example:

SELECT *
FROM Employees
WHERE Department = 'IT'
AND Salary > 50000;

Result:

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

Benefits:

More precise filtering.

Using OR Operator

OR returns records that satisfy at least one condition.

Example:

SELECT *
FROM Customers
WHERE City = 'Jaipur'
OR City = 'Delhi';

Result:

Customers from Jaipur or Delhi.

Benefits:

Broader filtering.

Using NOT Operator

NOT excludes matching records.

Example:

SELECT *
FROM Employees
WHERE NOT Department = 'HR';

Result:

All employees except HR employees.

Applications:

Exclusion reporting.

Using BETWEEN

BETWEEN filters values within a range.

Syntax

SELECT *
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Example:

SELECT *
FROM Sales
WHERE Revenue BETWEEN 50000 AND 100000;

Result:

Sales between ₹50,000 and ₹100,000.

Applications:

Revenue analysis.

Using IN Operator

IN simplifies multiple-value filtering.

Example:

SELECT *
FROM Customers
WHERE City IN ('Jaipur', 'Delhi', 'Mumbai');

Result:

Customers from selected cities.

Benefits:

Cleaner queries.

Using LIKE Operator

LIKE searches for patterns.

Starts With

Example:

SELECT *
FROM Customers
WHERE CustomerName LIKE 'R%';

Result:

Names starting with R.

Examples:

• Rahul
• Rakesh
• Rohan

Ends With

Example:

SELECT *
FROM Customers
WHERE CustomerName LIKE '%a';

Result:

Names ending with “a”.

Contains

Example:

SELECT *
FROM Customers
WHERE CustomerName LIKE '%sh%';

Result:

Names containing “sh”.

Applications:

Search functionality.

Using IS NULL

Find missing values.

Example:

SELECT *
FROM Employees
WHERE Email IS NULL;

Result:

Employees without email addresses.

Applications:

Data quality checks.

Using IS NOT NULL

Find available values.

Example:

SELECT *
FROM Employees
WHERE Email IS NOT NULL;

Result:

Employees with email addresses.

Applications:

Data completeness validation.

Filtering Data in Sales Analytics

Example:

SELECT *
FROM Sales
WHERE Revenue > 100000;

Benefits:

Identify top-performing transactions.

Applications:

Revenue reporting.

Filtering Data in Customer Analytics

Example:

SELECT *
FROM Customers
WHERE City = 'Jaipur';

Benefits:

Regional customer analysis.

Applications:

Marketing campaigns.

Filtering Data in HR Analytics

Example:

SELECT *
FROM Employees
WHERE Department = 'Finance';

Benefits:

Department-specific reporting.

Applications:

Workforce analysis.

Filtering Data in Financial Analytics

Example:

SELECT *
FROM Transactions
WHERE Amount > 50000;

Benefits:

Monitor high-value transactions.

Applications:

Financial audits.

Combining Multiple Conditions

Example:

SELECT *
FROM Sales
WHERE Region = 'North'
AND Revenue > 100000
AND OrderDate >= '2026-01-01';

Benefits:

Highly targeted reporting.

Applications:

Executive dashboards.

Common Mistakes in Filtering Data

Incorrect Data Types

Example:

WHERE Revenue = '50000'

Use appropriate numeric formats.

Missing Quotes for Text

Incorrect:

WHERE City = Jaipur

Correct:

WHERE City = 'Jaipur'

Confusing AND and OR

May produce unexpected results.

Ignoring NULL Values

Can lead to incomplete analysis.

Avoid these mistakes to improve query accuracy.

Best Practices for Filtering Data

Use Specific Conditions

Improve relevance.

Combine Conditions Carefully

Ensure logical accuracy.

Validate Results

Confirm expected outputs.

Use IN for Multiple Values

Simplify queries.

Handle NULL Values Properly

Improve data quality analysis.

Optimize Queries

Retrieve only necessary records.

These practices improve SQL performance and reporting quality.

Filtering Data in Data Analytics

Data Analysts use Filtering Data for:

• Report Generation
• Dashboard Development
• KPI Analysis
• Customer Segmentation
• Revenue Tracking
• Trend Analysis

Filtering Data is one of the most frequently used SQL skills in analytics.

Advantages of Filtering Data

Organizations benefit through:

• Faster reporting.
• Improved analysis.
• Better decision-making.
• Efficient data retrieval.
• Enhanced business intelligence.
• More targeted insights.

Filtering Data helps transform large datasets into meaningful business information.

Learning Outcomes

After completing this lesson, you will be able to:

• Understand Filtering Data in SQL.
• Use the WHERE clause effectively.
• Apply comparison operators.
• Use AND, OR, and NOT conditions.
• Filter data using BETWEEN, IN, and LIKE.
• Handle NULL values correctly.
• Apply Filtering Data techniques in Data Analytics projects.

Frequently Asked Questions (FAQs)

What is Filtering Data in SQL?

Filtering Data is the process of retrieving only records that meet specific conditions.

Which SQL clause is used for Filtering Data?

The WHERE clause is used for Filtering Data.

What does BETWEEN do?

BETWEEN retrieves records within a specified range.

What is the purpose of LIKE?

LIKE searches for text patterns.

What does IN do?

IN allows filtering using multiple values.

What is IS NULL used for?

IS NULL identifies missing values.

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.

Why is Filtering Data important in Data Analytics?

It allows analysts to focus on relevant information and generate meaningful insights.

Explore More Learning Opportunities

Want to master SQL, reporting, and Data Analytics?

Click here for more free courses