TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
15
)
how to update column value in sqlserever
Fetch data of same table from different server using SSIS.