SQL> select * from test_5;NAME XH
---- ----------
a 0
a
b
b SQL> select name,row_number() over(partition by name order by name) xh from test_5;NAME XH
---- ----------
a 1
a 2
b 1
b 2
---- ----------
a 0
a
b
b SQL> select name,row_number() over(partition by name order by name) xh from test_5;NAME XH
---- ----------
a 1
a 2
b 1
b 2
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货