SQL to find employees who have the highest salary in their departments

By Tewodros Date Posted: Sep. 27, 2021 Hits: 924 Category: Database Total Comment: 0 A+ A-

In this exercise we are going to write a SQL to find employees who have the highest salary in their departments

select * from Employee where salary in (
select max(e.Salary)
from Employee e
group by DepartmentId
)

Related Blogs

SQL rank, dense rank, partition

SQL interview questions

Find Customers who didn't make an Order SQL

Customers Earn More than their Managers SQL

SQL select top earners by department

Find insert position in sorted array

Find kth largest elements In unsorted array

Find Longest Common Prefix (LCP) of string

Find Starting and Ending Index of a Key in a Sorted List

Find Count of Pairs whose difference equal to Target Algo

Please fill all fields that are required and click Add Comment button.
Name:*	Enter your name!
Email:*	Enter your email!
Comment:* (Only 2000 char allowed)	Enter a comment!
Security Code:*	Please enter the security code. cqtcau