cydbetter的博客

需求：先按员工编号分组排序，然后给每个分组从1,2...排序分析：需要Row_Number() OVER  语法解决：    SELECT emp_no,degree, Row_Number() OVER (partition by emp_no ORDER BY degree desc) rank FROM t_hrm_education        说明，先按emp_no分组，组内再按deg...