DENSE_RANK

RANK() : function always returns sequential order for each record.DENSE_RANK() : It returns continuous order for each record. Copy CodeCopiedUse a different BrowserSELECT empno, deptno, sal, mgr, RANK () OVER (PARTITION BY…