Nidhi Gupta
Apr 2, 2023

--

select name,department,salary from employees e1 where

(department,salary) in

(SELECT department ,max(salary) from employees e

group by department);

--

--

Nidhi Gupta
Nidhi Gupta

Written by Nidhi Gupta

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

No responses yet