oracle中部门工资降序排列,oracle面试题整理二(10级学员 乔宇整理)
时间: 2023-07-05 07:17:47 浏览: 54
您可以使用以下 SQL 语句来实现部门工资降序排列:
```
SELECT d.department_name, e.first_name, e.last_name, e.salary
FROM employees e
INNER JOIN departments d ON e.department_id = d.department_id
ORDER BY d.department_name ASC, e.salary DESC;
```
该语句将从 "employees" 表和 "departments" 表中获取相关信息,并按照部门名称升序和工资降序排序。