Saturday, February 22, 2014

Sum of Salary group by Dept id Query

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