How to find out 2nd or nth highest salary?

Maharudra Gadekar

6y18.2kLINQ

Dear All,

I want to find out 2nd highest or nth highest salary using linq....

bellow is my tried code:

List employees = new List()

{

new Employee { Id = 1, UserName = "Anil" , Salary = 5000},

new Employee { Id = 2, UserName = "Sunil" , Salary = 6000},

new Employee { Id = 3, UserName = "Lokesh" , Salary = 5500},

new Employee { Id = 4, UserName = "Vinay" , Salary = 7000},

new Employee { Id = 5, UserName = "Vijay" , Salary = 6000},

new Employee { Id = 6, UserName = "vikas" , Salary = 6000}

};

Linq Query:

var result = employees.OrderByDescending(x => x.Salary).Select(x => x.Salary).Skip(1).Take(3 - 1).FirstOrDefault();

but return only one reocrd from this query.the actual result is return 3 records.

I am also try using tolist().

help me......

thanks in advance

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty6y ago
Hey if you want all records having nth highest salary then try the below code
var result = employees.Where(x1 => x1.Salary == employees.OrderByDescending(x => x.Salary)
        .Select(x => x.Salary).Distinct().Take(NthNumber)
        .Skip(NthNumber - 1).FirstOrDefault()).ToArray();
Ravi Patel6y ago
Hi ,

var salary = employees.OrderByDescending(x => x.Salary).Select(x => x.Salary).Skip(1).FirstOrDefault().Salary;

var result =employees.where(x => x.Salary==salary).Select(x => x.Salary).Tolist();

foreach(var item in result)
{
console.writeln(salary); // it will print same salary three time ie 6000 as per your expectation actual result is return 3 records.
}
Amit Mohanty6y ago
Hey Maharudra,

The below query is working fine. If you want 2nd highest no then in place of NthNumber pass 2. It will give you the 2nd highest salary.
Maharudra Gadekar6y ago
Hi Navnth,

var result = employees.OrderByDescending(x => x.Salary).Skip(1).First();

Above query also return not expacted result....thats take only 2 max no
Maharudra Gadekar6y ago
Hi amit,

var result = employees.OrderByDescending(x => x.Salary).Select(x => x.Salary).Distinct().Take(NthNumber).Skip(NthNumber - 1).FirstOrDefault();

above your query not return expected answer. take 2nd max no.
i want to 2nd highest salary .....
Amit Mohanty6y ago
Hey try this
var result = employees.OrderByDescending(x => x.Salary)
                    .Select(x => x.Salary).Distinct().Take(NthNumber)
                    .Skip(NthNumber - 1).FirstOrDefault();
Siddharth Gajbhiye6y ago
Please g through this link in that u can find all your queries related to nth highest salary

https://www.youtube.com/watch?v=fvPddKyHxpQ
Navaneeth Krishnan6y ago
2nd highest

var result = employees.OrderByDescending(x => x.Salary).Skip(1).First();

Please refer below linq if need
https://www.tutorialsrack.com/articles/77/find-2nd-3rd-or-nth-highest-salary-using-linq