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

[@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

[@nayabmalik6064]

very easy and helpful explanation thank you

[@StartPracticing]

Your welcome

[@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]

😇