Answers | Knowledgebase

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