Rank Issue

[#1]

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

[avinashelite]

if you have got the answer mark the correct answer  and close this thread