Row Number, Rank and Dense Rank in sql | Analytical functions explained

This video shows the difference between row_number, rank and dense_rank analytical functions in oracle database with appropriate easy to understand examples, along with it the video demonstrates the different output obtained when using either of the three functions. Apart from simple explanation of the function we also show how partition by and order by clause can be used with the functions for tacking day to day scenarios.

If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below :

Other Playlists:

Content and video created by : Kishan Mashru

[dazzlerdude]

But why use rank instead of dense rank? Clearly dense rank makes sense.... Can you help me understand why should we use rank and which situation rank is used instead of dense rank?

[vallimuthaiyah]

can v use partition by clause along with rank and dense rank function ??