Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var em = from e in emp
- group e by new { e.Salary, e.Id }
- into gEmp
- let avgsal = (gEmp.Sum(t => t.Salary) / gEmp.Count())
- where gEmp.Key.Salary == avgsal
- select new { gEmp.Key.Salary, gEmp.Key.Id };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement