Oracle interview question, Difference between Rank and Dense Rank

Published: 01 July 2018
on channel: Siva Academy

104,829

859

Oracle interview question Difference between Rank and Dense Rank

Both RANK() and DENSK_RANK() function gives the ranking within the ordered partition of data, However if same rank is assigned to more than one record, then the next rank(s) will be skipped by RANK() function, whereas, the ranks are consecutive for DENSE_RANK. No ranks will be skipped in case of DENSE_RANK even if more than one row are assigned with same rank.

List of all the SQL and PLSQL interview questions
https://easy-learning-tech.blogspot.c...

Watch video Oracle interview question, Difference between Rank and Dense Rank online without registration, duration hours minute second in high quality. This video was added by user Siva Academy 01 July 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 104,829 once and liked it 859 people.

1,158