Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have attached an image with Rank function implemented for EmpID and their respective Salary.
There are 4 Employes which have the same salary and Ranked as 4-5 and 8-9.
Now if I Group the Ranks into A & B, so that I can give different Ranks (i.e. the same salary gets divided into two groups) to the same salaries of different employees.
Kindly assist me implementing the same, using Rank function (without sorting)
EmpID, Salary, Rank, Group
Annie 8500 1, A
Proj 7000 2, A
Pith 6500 3, A
Rossel 5000 4-5, A
Zen 5000 4-5, A
Richie 4500 6, A
Paul 3000 7, A
Rahim 2000 8-9, A
Reshma 2000 8-9, B
Rose 1000 10, B
Thanks in advance
if you have got the answer mark the correct answer and close this thread