I Want The query for Grouping the salary in each dept and di

Question

Emp table has EmoID  FirstName  LastName  MangerId  Salary  HierDate Department Table Has DeptId  DeptName I Want The query for Grouping the salary in each dept and display if its > 30k

Manoj Bhoir · Answer

Hi As per your question there is no relation between your two tables Emp and Department. So if you want Department wise salary you have to add DeptId column in your Emp table so that you can join these two tables. After adding DeptId in Emp table you can use this query : Select * From ( Select A . DeptID  DeptName  SUM ( A . Salary ) As Salary From EMP A INNER JOIN Department B ON A . DeptId = B . DeptID Group BY A . DeptID  DeptName ) X Where X . Salary > 30000

N Vinodh · Answer

Dear Fernandes Please follow this link for achieving this query You just modify the code for example get the salary and department https://msdn.microsoft.com/en-IN/library/ms181567.aspx Please mark 'if accepted answer'