Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Row_number, rank and dense_rank analytic functions

User_SS7U9Aug 1 2022

Wouldnt it be better to have one function with 1 parameter which can have 3 values only, instead of 3 seperate functions. ie

ROW_NUMBER(ROW_NUMBER|RANK|DENSE_RANK) ,and ROW_NUMBER being the default)
Row_number = row_number() = row_number(row_number)
Rank = row_number(RANK)
DENSE_RANK = row_number(DENSE_RSNK)

Comments
Post Details
Added on Aug 1 2022
3 comments
432 views