Apr 2, 2023
select name,department,salary from employees e1 where
(department,salary) in
(SELECT department ,max(salary) from employees e
group by department);
select name,department,salary from employees e1 where
(department,salary) in
(SELECT department ,max(salary) from employees e
group by department);
Azure Data Engineer 👨💻.Heading towards cloud technologies expertise✌️.