This example deletes rows from the employee table for managers who have less work experience than their employees. This delete performs a self-join on the employee table:
DELETE FROM employee AS managers
WHERE managers.deptno = employee.deptno
AND managers.jobtitle IN ('Manager', 'Vice Pres')
AND employee.yrsexp > managers.yrsexp;