get the latest record from the list .

Dear both Uttam Chaturvedi,Sachin Singh the query Linq works as the SQL for this is provided by Uttam Chaturvedi so should I mark him even though you translated it into Linq there is no option to mark two as correct.

Uttam Chaturvedi can you share in LINQ

Check this:

List students = new List
{
    new Student { ID = 1, Student_Name = "ABC", Marks = 78, Course_ID = 1 },
    new Student { ID = 2, Student_Name = "HHH", Marks = 88, Course_ID = 3 },
    new Student { ID = 3, Student_Name = "ABC", Marks = 89, Course_ID = 1 },
    new Student { ID = 4, Student_Name = "ABC", Marks = 99, Course_ID = 1 },
    new Student { ID = 5, Student_Name = "CCC", Marks = 67, Course_ID = 2 },
    new Student { ID = 6, Student_Name = "HHH", Marks = 76, Course_ID = 3 }
};

var latestRecords = students
    .GroupBy(student => student.Course_ID)
    .Select(group => group.OrderByDescending(student => student.ID).First())
    .OrderBy(student => student.ID);

foreach (var record in latestRecords)
{
    Console.WriteLine($"ID: {record.ID}, Student_Name: {record.Student_Name}, Marks: {record.Marks}, Course_ID: {record.Course_ID}");
}

I need this in Linq in SQL I did it thanks for the help

Here you go with sql query to get latest records by id. Assuming your table name is student

SELECT * FROM  dbo.student 
WHERE id IN 
(SELECT MAX(id) FROM  dbo.student GROUP BY student_name)

Please accept answer, if you find it useful