Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. var em = from e in emp
  2. group e by new { e.Salary, e.Id }
  3. into gEmp
  4. let avgsal = (gEmp.Sum(t => t.Salary) / gEmp.Count())
  5. where gEmp.Key.Salary == avgsal
  6. select new { gEmp.Key.Salary, gEmp.Key.Id };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement