V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
• 请不要在回答技术问题时复制粘贴 AI 生成的内容
This topic created in 2393 days ago, the information mentioned may be changed or developed.
题目：部门工资前三高的所有员工
我的 sql 如下
select t.Name as Department, Employee.Name as Employee, Employee.Salary from Employee ,
(
SELECT *, IFNULL((
SELECT DISTINCT(salary) from Employee, (select @i :=0, @pre := -1) t
where Employee.DepartmentId = Department.id
HAVING ( @i := @i + (@pre != (@pre := salary))) = 3
ORDER BY salary desc
), 0) as salary from Department
) as t
where t.id = Employee.DepartmentId and Employee.Salary >= t.Salary
order by t.id asc, Employee.Salary desc;
本地 sql 执行结果 ok，leetcode 执行代码也 ok，提交审核就挂了！不知道问题在哪儿！
 |
1
c6h6benzene Oct 16, 2019 via Android
原谅我的第一反应是 Row_Number 或者 Rank
|
 |
2
wd Oct 17, 2019 via iPhone
mysql 支持 window function 吗？
|
Select Language