Below is a sample code snippet demonstrating how to retreive the max row with the group by in LINQ Query using C# .
For example , assume that the table name is employee and we want to retreive the maximum experience based on the designation .
In SQL Query , we would do something like this
Select max(experience) as experience, Designation from Employee Group BY Designation
How to get the MAX row with group by in LINQ query using C# ?
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace GinktageConsoleApp { class Program { static void Main(string[] args) { List<Employee> employees = new List<Employee>(); employees.Add(new Employee { Name = "Rajni", Experience = 6 , Designation="Senior Software Engineer" }); employees.Add(new Employee { Name = "Naveen", Experience = 4, Designation = "Senior Software Engineer" }); employees.Add(new Employee { Name = "Praveen", Experience = 1, Designation = "Trainee" }); employees.Add(new Employee { Name = "Michael", Experience = 4, Designation = "Software Engineer" }); var query = from employee in employees group employee by employee.Designation into g select new { Designation = g.Key, Experience = (from exp in g select exp.Experience).Max() }; } } public class Employee { public string Name { get; set; } public int Experience { get; set; } public string Designation { get; set; } } }