groupby:
var query = from myemp in dc.Emps
join d in dc.Depts on myemp.Dept_Id equals d.DeptId
join dg in dc.Desigs on myemp.Desig_Id equals dg.DesigId
group myemp.Salary by new
{
myemp.Dept
} into gs
select new
{
deptid = gs.Key.Dept.DeptId,
deptname = gs.Key.Dept.DeptName,
gropbydept = gs.Count(),
gropbysalary = gs.Sum(),
};
No comments:
Post a Comment