Top LTIMindtree SQL Interview Questions | Data Engineering Career Guide 2024 | Data Engineering

[@sibanandaroutray9721]

This question is for how many years of experience candidates ?

[@siddu1036]

For duplicates,
With CTE
(Select *, row_number() over (partition by dept,name,salary order by salary) as rnk from emp)
SELECT * from CTE where rnk = 1
Will get only the records with out duplicate

[@arsalanansari5066]

To solve Question 1 use the following query:
select name,dept,salary from emp e
where salary = (select max(salary)
from emp
where dept = e.dept
)
order by dept