Comments by Member 13768545 (Top 1 by date)

the question is solved.
List<v_salaries> Grdquery = db.V_Salaries.Where(i => i.InOut_Flag == 0 && i.Year == cariyil).OrderBy(x => x.Worker_Name).ThenBy(x => x.Year_Name)
.GroupBy(g => g.Worker_Code, (Key, a) => a.OrderByDescending(b => b.Id).FirstOrDefault())
.ToList();