LeetCode Medium 184 "Department Highest Salary" Amazon Interview SQL Question With Explanation

No video

LeetCode Medium 184 "Department Highest Salary" Amazon Interview SQL Question With Explanation

Рет қаралды 3,534

Күн бұрын

Question: leetcode.com/p...
In this video I solve and explain a medium difficulty leetcode SQL question using MySQL query. This question has been asked in Apple, Facebook, Amazon, Google, Adobe, Microsoft, Adobe interviews or what we popularly call FAANG interviews.
I explain the related concept as well. This question includes points to keep in mind to develop SQL queries.
LeetCode is the best platform to help you enhance your skills, expand your knowledge and prepare for technical interviews.
If you found this helpful, Like and Subscribe to the channel for more content.
#LeetCodeSQL #FAANG #SQLinterviewQuestions

Пікірлер: 4

@TuringTested01 Жыл бұрын

Very simple very simple mat kiya karo, it depends on the level the person who is trying the question is, it demotivates people who are not able to solve if they are at beginner level. Bar bar very simple very simple bol rahe ho

@dwaipayansaha4443 2 жыл бұрын

Hi there! I have two questions. a) We could have used inner join too as in this question our subject of interest is highest salary per dept. So even if there are some people with dept name missing, it will not bea problem b) We could have used the rank function also and select the rank 1 records ,right Please correct me if I am wrong. Thanks,

@rawat7203 Жыл бұрын

select Department.name as Department , x.name as Employee , x.salary as Salary from (select departmentId ,name, salary, dense_rank() over(partition by departmentId order by salary desc ) as ranking from Employee) as x join Department on(x.departmentId = Department.id) where ranking = 1 or ranking = 2 or ranking = 3

@shubhamkumargupta3543 7 ай бұрын

# MYSQL query using rank method with cte as (select d.name as Department, e.name as Employee, e.salary, rank() over(partition by e.departmentId order by -e.salary) as salary_rank from Employee e join Department d on e.departmentId = d.id ) select Department, Employee, salary from cte where salary_rank =1;