Lowest salary for each dept without any duplicates in sql query

CNH

Input:

Output:

Solution:

select Emp_ID,Emp_Dept,Salary from (select * , row_number() over(partition by Emp_Dept order by Salary asc) as rn from empdata)sb where rn = 1