Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
15
Reply
How to get department Name of Employees Total Maximum Salary
Sunny Kathariya
8 years ago
476
Reply
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
Post
Reset
Cancel
Answers (
15
)
Next Recommended Forum
Encryption and Decryption
Fetch data of same table from different server using SSIS.