SQL Tutorial

🎯 Filtering Data in SQL

Filtering helps you narrow down your query results by including only rows that meet specific criteria. This is done using the WHERE clause.

🧪 Example: Get Students Who Scored Above 80

SELECT name, marks
FROM Students
WHERE marks > 80;
  

This query filters out students whose marks are above 80.

🎮 Try It Yourself

Here’s a sample table named Products:

🧩 Your Task: Write a query to show only those products whose category is Furniture and price is above 2000.

🔍 Common Operators for Filtering

• = : Equal to
• >, < : Greater than / Less than
• >=, <= : Greater or equal / Less or equal
• != or <> : Not equal to
• AND, OR : Combine multiple conditions
• IN, NOT IN : Match any (or none) in a list
• LIKE : Match a pattern (e.g., 'A%' for names starting with A)

🎲 Bonus Challenge

Write a query to fetch employees from the Employees table who:

• Have a salary more than 40,000
• AND belong to the "Sales" department

📌 Summary

• Use the WHERE clause to filter records.
• Combine filters with AND, OR, NOT.
• Use LIKE or IN for more flexible matching.

Next Topic ➡️: Learn how to filter using BETWEEN and LIKE to handle ranges and patterns!