43. Department Top Three Salaries | SQL Interview Questions and Answers

[@nayabmalik6064]

very easy and helpful explanation thank you

[@StartPracticing]

Your welcome

[@HuyNguyenQuang-ow9wj]

Best answer # Write your MySQL query statement below
WITH t1 AS (
SELECT
d.name Department, e.name Employee, salary,
DENSE_RANK() OVER(PARTITION BY d.name ORDER BY salary DESC) rank_salary
FROM Employee e
JOIN Department d
ON e.departmentId =d.id)
SELECT Department, Employee, salary
FROM t1
WHERE rank_salary

[@iam_kazmi]

Eid Mubarak Mam 🎉

[@StartPracticing]

Thank you. Eid Mubarak

[@YourAashique]

Eid Al Fitr 1445 H Mubarak 🌙🤍

[@StartPracticing]

Thank you Eid mubarak

[@Sonurajputshorts]

Jai shree Ram

[@StartPracticing]

😇