27.删除所有销售部的员工数据.sql

介绍了一些数据库中常用的语句

delete employees
from employees inner join departments
on employees.department=departments.depid
where departments.depname='销售部'