I Wrote Down This Query:
select d.Name as "Department",sum(e.Salary)as "Salary" from Employee e, Department d where d.Dept_ID=e.Dept_ID group by d.Name
o/p
But i want to That Department Which is Total Salary is Highest then other in output there is total salary of employees is Display of each Department but i want to display only Highest Total Salary Department Like '.Net' because its Total Salary higher Then Other
This Is my Employee Table
This is My Department Table