List top 3 youngest ages of employees dept wise using SQL.

• Use GROUP BY to group employees by department.

• Use ORDER BY to sort ages in ascending order.

• Use LIMIT to get top 3 youngest ages.

• Use MIN to get...read more

select * from (

select *,

rank() over (partition by dept_name order by age desc) as rnk,

dense_rank() over (partition by dept_name order by age desc) as dense_rnk

from emp) sq

where dense_rnk<4;

select age from(select name,age, row_number() over(partition by dept order by age asc) as rn

from EMPLOYEE) x where x.rn<2;

• select age from employees group by dept order by age asc limit 3