HANA SQL - RANK函数

2018-10-31

HANA SQL - RANK函数

rank函数问题：

表：employee

找出表中不同departmenid里salary最高的人员信息，筛选结果如下

解法：

select name,salary,departmentid from (
    select 
       rank() over(partition by departmentid order by salary desc) as rank ,
       name,
       salary,
       departmentid
    from employee )
where rank