SQL DELETE: Examples

DELETE FROM dependents 
WHERE
    dependent_id = 16;

SELECT 
    count(*)
FROM
    dependents
WHERE
    dependent_id = 16;

DELETE FROM dependents 
WHERE
    employee_id IN (100 , 101, 102);

DELETE
FROM
	employees
WHERE
	employee_id = 192;

DELETE
FROM
	dependents
WHERE
	employee_id = 192;

DELETE
FROM
	employees
WHERE
	employee_id = 192;

SELECT * FROM countries;

SELECT * FROM departments;

SELECT * FROM dependents;

SELECT * FROM employees;

SELECT * FROM jobs;

SELECT * FROM locations;

SELECT * FROM regions;

Execute

Clear Beautify Minify

Reload