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
