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

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


side

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

  )


Tags



Back to Top



Related Blogs






Please fill all fields that are required and click Add Comment button.

Name:*
Email:*
Comment:*
(Only 2000 char allowed)


Security Code:* nvcveh

Back to Top