Below is a sample code snippet demonstrating how to retreive the max row with the group by in Lambda Expression 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 Lambda Expression 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 queryResult = employees.GroupBy(employee => employee.Designation).Select(g => new
            {
                SerialDesignation = g.Key,
                experience = g.Max(row => row.Experience)
            });
            Console.ReadLine();

        }
    }
    public class Employee
    {
        public string Name { get; set; }
        public int Experience { get; set; }
        public string Designation { get; set; }
    }
}