Sunny Kathariya

Sunny Kathariya

  • NA
  • 33
  • 1.2k

How to get department Name of Employees Total Maximum Salary

Jun 7 2016 4:17 AM
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

Answers (15)