OPER@TL>select * from test;AAA BBB -------------------- ---------- a 1 a 1 a 2 a 2 a 2 a 3已选择6行。OPER@TL>select aaa,bbb,row_number() over(partition by bbb order by bbb)-1 rn 2 from test;AAA BBB RN -------------------- ---------- ---------- a 1 0 a 1 1 a 2 0 a 2 1 a 2 2 a 3 0已选择6行。
-------------------- ----------
a 1
a 1
a 2
a 2
a 2
a 3已选择6行。OPER@TL>select aaa,bbb,row_number() over(partition by bbb order by bbb)-1 rn
2 from test;AAA BBB RN
-------------------- ---------- ----------
a 1 0
a 1 1
a 2 0
a 2 1
a 2 2
a 3 0已选择6行。