Oracle interview question, Difference between Rank and Dense Rank
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...