Sum Employees salary according to depatments.

Question

In sql server two tables is given, employee table and department table, and employee  table contains approx 50 employees and his/her salary on each departments vise, and departments table contains department_id and department name, i want to  to exit out sum of salary of every department separately according to each departments .

Answer 1

Hi...........
DC
Please see url :http://msdn.microsoft.com/en-us/library/ms227560.aspx
                                                                                             I hope help to you.