Difference Between RANK() and DENSE_RANK() in SQL with an Example
May 9, 2019
SQL INTERVIEW QUESTIONS
There is a small difference between RANK() and DENSE_RANK() analytic functions. Lets take an example to illustrate this. 1. select ename,deptno,sal,RANK() OVER (PARTITION BY deptno ORDER BY SAL) from …