Query to find department wise highest salary in an organisation

• Use GROUP BY clause to group data by department

• Use MAX() function to find highest salary in each department

• Join the tables if necessary t...read more