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 :
union and union all : • UNION AND UNION ALL SET OPERATOR IN O...
char and varchar2 : • DIFFERENCE BETWEEN CHAR AND VARCHAR2 ...
replace and translate : • Replace and Translate in sql
procedure and function : • Difference between Procedure and Func...
in and exists : • IN VS EXISTS VS JOIN, performance
delete and truncate : • Difference between Delete and Truncat...
%type and %rowtype : • type and rowtype PL/SQL | difference ...
Subscribe to the channel : / @kishanmashru
Other Playlists:
Data Warehousing Concepts: • Data Warehousing Concepts
Python and Database: • Python | How to Install python packages
SQL and PL/SQL Interview Questions: • SQL AND PL/SQL INTERVIEW QUESTIONS
SQL and PL/SQL concepts: • SQL and PLSQL
Content and video created by : Kishan Mashru
