摘要:
row_number() over ([partition by col1] order by col2) ) as 别名表示根据col1分组,在分组内部根据 col2排序而这个“别名”的值就表示每组内部排序后的顺序编号(组内连续的唯一的),[partition by col1] 可省略。SELECT jjdb.jjdbh,fkdb.fksj, ROW_NUMBER() OVER(PARTITION BY jjdb.jjdbh ORDER BY fkdb.fksj) rank FROM jjdb, fkdb WHERE jjdb.jjdbh = fkdb.jjdbh(+)
阅读全文