Apr 2, 2023
select department,salary, name from (
SELECT department,salary, name ,
row_number()over(partition by department order by salary desc) as row_num
from employees ) as a
where row_num <=3;
select department,salary, name from (
SELECT department,salary, name ,
row_number()over(partition by department order by salary desc) as row_num
from employees ) as a
where row_num <=3;
Azure Data Engineer 👨💻.Heading towards cloud technologies expertise✌️.