Try it Yourself: SQL Delete

SQL Delete

Language: SQL

-- Remove one employee by id
DELETE FROM Employees
WHERE employee_id = 101;

-- Remove every employee in a closed department
DELETE FROM Employees
WHERE department = 'Legacy';

-- Remove one employee by id
DELETE FROM Employees
WHERE employee_id = 101;

-- Remove every employee in a closed department
DELETE FROM Employees
WHERE department = 'Legacy';

Output

Click Run to execute this code.