Given the employees and departments table, write a query to get the top 3 highest employee salaries by department.

Given the employees and departments table, write a query to get the top 3 highest employee salaries by department.

题目类型: 技术面试题

这是一道技术面试题，常见于澳洲IT公司面试中。

难度: medium

分类: problem-solving

标签: Atlassian Coding

目标岗位: Software Engineer

目标公司: Atlassian

参考答案摘要

用窗口函数：按 department 分区，对 salary 进行 RANK()/DENSE_RANK()（降序），筛选 rank

本题提供 STAR 原则详细解答和技术解析，登录匠人学院学习中心即可查看完整答案。