select row_number() over(partition by c1 order by c2) cno,c1,c2 from A;
select row_number() over(partition by c1 ) cno,c1,c2 from A;
select ROW_NUMBER() OVER (PARTITION BY C1 ORDER BY C1) ,a.* from A
select row_number() over(partition by c1 ) cno,c1,c2 from A;
如果使用row_number则应该使用rowid排序,而不是C2select row_number() over(partition by c1 order by rowid) cno,c1,c2 from A;
select c1 , c2 , row_number() over(partition by c1 order by c1 ) cno,c1,c2 from A; 或者 select c1 ,c2 , rank()over(partition by name order by id ) from A ; 看楼主对重复值的排序不同使用不同的语句了
或者
select c1 ,c2 , rank()over(partition by name order by id ) from A ; 看楼主对重复值的排序不同使用不同的语句了