youtor.org
184 Department Highest Salary LeetCode Hindi
#############################
Video Source: www.youtube.com/watch?v=IFTu2GcyswU
Write a solution to find employees who have the highest salary in each of the departments. • Return the result table in any order. • id is the primary key (column with unique values) for this table. It is guaranteed that department name is not NULL. • Each row of this table indicates the ID of a department and its name. • Problem link - https://leetcode.com/problems/departm... • query - • select d.name as Department ,e.name as Employee, e.salary salary • from • Department d • join • Employee e • on d.id = e.departmentId • WHERE (e.departmentId,e.salary) IN • (select departmentId,max(salary) from employee • group by departmentId) • #LeetCodeSQL #FAANG #SQLinterviewQuestions
#############################
