select u.DeptId,SUM(Salary) as TotSalary from tblUsers u group by u.DeptId
tbl_Dept:--
DeptId int
DeptName nvarchar(50)
tblUsers:--
UserID int Unchecked
FirstName nvarchar(50) Checked
LastName nvarchar(50) Checked
Phone nvarchar(50) Checked
Email nvarchar(50) Checked
Salary decimal(18, 0) Checked
DeptId int Checked
No comments:
Post a Comment