摘要: select * from ( SELECT empid,salary, row_number() OVER (partition by deptid ORDER BY salary desc) rank FROM employee ) where rank =1 create table empl 阅读全文
posted @ 2015-12-31 18:59 Alvin 阅读(172) 评论(0) 推荐(0) 编辑