Find 2nd max salary using linq

Question

I have following sql query for finding 2nd max salary.

Select * From Employee E1 Where
    (2) = (Select Count(Distinct(E2.Salary)) From Employee E2 Where
        E2.Salary > E1.Salary)

I want to convert it into Linq statement.

Answer 1

I think what you're asking is to find the employee with the second-highest salary?

If so, that would be something like

var employee = Employees
    .OrderByDescending(e => e.Salary)
    .Skip(1)
    .First();

If multiple employees may have equal salary and you wish to return an IEnumerable of all the employees with the second-highest salary you could do:

var employees = Employees
    .GroupBy(e => e.Salary)
    .OrderByDescending(g => g.Key)
    .Skip(1)
    .First();

(kudos to @diceguyd30 for suggesting this latter enhancement)