select d.department_id,d.department_name,max(e.salary),min(salary) from

emp e join departments d

on e.department_id =d.department_id

group by d.department_id , d.department_name;

BY using aggregate function of min() and max() we can find the minmum salary and maximum in a single query.

• select min(salary) as minimum_salary from table_name;

• select max(salary) as maximum salary fro...read more