Part 13: Filtering Records with the WHERE Clause

The WHERE clause filters rows before any aggregation, grouping, or output formatting occurs.

1. Basic WHERE Syntax

SELECT first_name, department, salary 
FROM employees 
WHERE department = 'Engineering';

2. Filtering on Multiple Conditions

SELECT first_name, salary, hire_date
FROM employees
WHERE salary > 85000 AND hire_date >= '2023-01-01';

Key Takeaways

• WHERE restricts which rows are retrieved based on boolean expressions.
• The database evaluates WHERE before SELECT expressions!

In Part 14, we explore Comparison Operators in SQL!