The MySQL DENSE_RANK Function is used to return sequential numbers starting from 1 based on the ordering of rows imposed by the ORDER BY clause. When you have two records with the same data, then it ...
select ED.Employee_Id,ED.First_Name,ED.Last_Name,ED.Gender,ES.Salary,dense_rank() over (order by salary desc) as Sal_Rank ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback