WHERE

WHERE

WHERE — allows users to filter records based on specific conditions. 

SELECT * FROM employees
WHERE department = 'Sales';
Selection of all employees in the Sales department. 
UPDATE employees
SET salary = salary * 1.10
WHERE department = 'Sales';
Increasing the salary of all employees in the Sales department by 10%. 
DELETE FROM employees
WHERE department = 'Sales';
Deletion of all employees in the Sales department. 
SELECT * FROM employees
WHERE department = 'Sales' AND salary > 50000;
Selection of all employees in the Sales department with a salary greater than 50,000.

Can be used by users when selecting, updating, or deleting records.

Related concepts

→
WHERE
→

WHERE — Structure map

Clickable & Draggable!

WHERE — Related pages:

SQL Introduction

SQL Where

SQL Create

SQL Insert

SQL Subqueries

SQL Aggregation