CodePudding user response:
Db2 row_number () over () is equal to the oracle of row_number () over ()CodePudding user response:
ROW_NUMBER () OVER (PARTITION BY the COLUMN ORDER BY COLUMN)
Simple said row_number () from the beginning of the 1, recorded for each group to return to a number, the row_number () OVER (ORDER BY XLH DESC) is to list all descending XLH first, then for no article after descending XLH record returns a sequence number, row_number () OVER (PARTITION BY COL1 ORDER BY COL2) said, according to the grouping COL1 within the grouping based on COL2 sorting, but this function calculating the value of the said internal sorted ORDER number in each group (group within the continuous only)