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

14 Aug 2016 | SQL Server

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: