sql - Oracle column number increase -


I know that to increase the row number in column 1 in column 1, when the column 2 value changes in oracle

What I'm looking for:

  COL1 COL2 COL3 | 1 2000 xx 1 2000 xy | 1 2000 xyz 2 3020 x | 2 3020 xiii | 3 5666666 UAU  

Any ideas?

I think you are looking for a window function:

 Choose  from row_number () over_table in form of col1, col2, col3 (col2 by col2 order split by);  

Comments

Popular posts from this blog

Member with no value in F# -

java - Joda Time Interval Not returning what I expect -

c# - Showing a SelectedItem's Property -