Nidhi Gupta
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;

--

--

Nidhi Gupta
Nidhi Gupta

Written by Nidhi Gupta

Azure Data Engineer 👨‍💻.Heading towards cloud technologies expertise✌️.

Responses (1)