SQL Interview Question | Flipkart |

[@vivekshirsat9249]

select company ,
max(salary) as highest_salary,
min(salary) as lowest_salary
from employee_info
group by company;

[@codinglake]

👍

[@chennakesavasreeramadas5504]

With sal as(select *,max(salary) over(partition by department) as max_sal, min(salary) over(partition by department) as min_sal
from emploee_info)
select * from sal

[@codinglake]

Nice