What would be the select Statement to find the Department wise Salary from Employee table?
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
Please use the CODE HIGHLIGHT Button to format/highlight your codes if any