how to find Max salary in sql from Row code example

Example 1: how to find max and min salary in sql

SELECT MAX(salary), MIN(salary) FROM employees;

Example 2: how to get max salary in each department in sql

SELECT firstname, MAX(salary)
FROM department d LEFT OUTER JOIN employee e
ON (d.department_id = e.department_id)
GROUP BY department_id;