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...
Watch video Oracle interview question, Difference between Rank and Dense Rank online, duration hours minute second in high quality that is uploaded to the channel Siva Academy 01 July 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 104,829 times and liked it 859 visitors.
