Have a Question?

If you have any question you can ask below or enter what you are looking for!



Deprtment wise Salary in Employee Table

What would be the select Statement to find the Department wise Salary from Employee table?

  Devbrat Tripathi

Hi, 

for department wise salary please use below query.

select dname,sum(Sal) from Dept
left join Employee ON DEPT.DeptNo=Employee.DeptNo
group by DName

  Rakesh Sharma       28 Aug 2016       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any