WHERE Clause and Filtering in SQL Server - Examples

Filter Employees by Department and Salary

Write a SQL query to find employees in the 'Marketing' department with a salary between 40000 and 70000.

Expected output: List of employees matching the department and salary criteria.

Hint: Use WHERE with AND and BETWEEN operators.

Find Customers with Email Domain

Write a SQL query to retrieve customers whose email ends with '@example.com'.

Expected output: Customers whose email addresses end with '@example.com'.

Hint: Use the LIKE operator with the % wildcard.

Filter Orders Not in a Specific Status

Write a SQL query to select orders where the status is not 'Completed'.

Expected output: Orders with statuses other than 'Completed'.

Hint: Use the NOT operator in the WHERE clause.

The WHERE clause filters rows returned by a query based on specified conditions, allowing retrieval of only relevant data.

You combine multiple conditions using logical operators such as AND, OR, and NOT.

'=' compares exact values, while LIKE allows pattern matching using wildcards like % and _.