ROW_NUMBER vs RANK function | RANK vs DENSE_RANK function | ROW_NUMBER vs RANK vs DENSE_RANK in SQL

ROW_NUMBER() vs RANK() function in SQL | RANK() vs DENSE_RANK() function in SQL| ROW_NUMBER vs RANK vs DENSE_RANK in SQL ROW_NUMBER function in SQL, RANK function in SQL, Partition Rank, DENSE_RANK function in SQL, Getting 3rd highest salary, the difference between ROW_NUMBER, RANK, and ROW_NUMBER function Agenda: ------------ Q01. What is the ROW_NUMBER() function in SQL? Q02. What is the RANK() function in SQL? Q03. What is the DENSE_RANK() function in SQL? Q04. What is the use of the PARTITION BY clause in SQL? Q05. Can you use ROW_NUMBER, RANK, or DENSE_RANK function without the ORDER BY clause? Q06. What is the difference between ROW_NUMBER() and RANK() function in SQL? Q07. What is the difference between RANK() and DENSE_RANK() function in SQL? Q08. Can you give any real use of ROW_NUMBER() function in SQL? Q09. Can you give any real use of RANK() function in SQL? Q10. Can you give any real use of DENSE_RANK() function in SQL?