Linq Query using Joins GroupBy

Question

// Classes Class Employee { EmployeeIDNameDesignationDateOfJoin } Class SalaryDetails { EmployeeID HRADABasicNetSalary } and then i added Collections of data's using List and List How to find 3rd highest netsalary using LINQ query ... I want result is IDNameDesignationBasicNetSalary. So here I want use join  groupby How can get it ?

Vulpes · Answer

If the lists are called 'employees' and 'salaries' try: var query = (from e in employees join s in salaries on e.EmployeeID equals s.EmployeeID orderby s.NetSalary descending select new {e.EmployeeID e.Name e.Designation s.Basic s.NetSalary}).ElementAt(2); Incidentally if there are several employees who have the joint third highest net salary and you want the whole group of them then you can use: var query2 = (from e in employees join s in salaries on e.EmployeeID equals s.EmployeeID group new {e.EmployeeID e.Name e.Designation s.Basic s.NetSalary} by s.NetSalary into g orderby g.Key descending select g).ElementAt(2);

Vulpes · Answer

To get the nth highest net salary you would of course use ElementAt(n - 1) rather than ElementAt(2). I don't really know of a better way to do this using LINQ though I suppose instead of ElementAt(n - 1) you could use Skip(n - 1).Take(1) though I doubt whether it's more efficient internally.

Vijay · Answer

thanks Vulpes ... i getting result from this..... Please let me know whether it having alternative way to get nth Highest Salary.... other possible ways

Linq Query using Joins, GroupBy