05.按部门号顺序查询employees表中所有数据.sql

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

select employees.empid,employees.name,departments.depname,
        employees.birthdate,  employees.salary
from departments INNER JOIN  employees
on departments.depid=employees.department
order by employees.department