07.查询employees表工资超过1500的开发部员工.sql

来自「介绍了一些数据库中常用的语句」· SQL 代码 · 共 6 行

select employees.empid,employees.name,departments.depname,
        employees.birthdate,  employees.salary
from departments INNER JOIN  employees
on departments.depid=employees.department
where departments.depname='开发部'and employees.salary>1500