资讯

select *,row_number () over (partition by column1 order by column2) as n from tablename 在上面语法中: PARTITION BY子句将结果集划分为分区。