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

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

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