终极总结window functions(附上测试sql)

赞一个lz，地里window function相关的帖子太少了

目前为止面试还没遇到过，学习一下

写得很清楚，谢谢楼主

总结的很好，谢谢分享

感谢楼主分享，对理解很有帮助！

想听lz讲rolling部分！

shirleykeat 发表于 2019-3-11 03:17
但是Leetcode SQL 版本一直没更新，刷题的时候用不上就很烦

LeetCode· MS SERVER 现在可以用了

lz 很赞，我也比较喜欢用window function. LZ 要不要更新一下rolling?

shirleykeat 发表于 2019-3-11 03:17
但是Leetcode SQL 版本一直没更新，刷题的时候用不上就很烦

you can use oracle or MySQL server,  I don't remember exactly which one, that allows windows function in leetcode

LC里MS SQL Server 支持window functions。 附上刚run成功的 Department Highest Salary那题：

select d.name as department, sub.name as employee, sub.salary as salary
from
(select name, salary, departmentid,
rank() over (partition by departmentid order by salary desc) as  'rank'
. 1point 3acres from employee) sub
inner join department d on sub.departmentid = d.id
where sub.rank = 1;