List the maximum salary of employee grouped by their department number.

Q. List the maximum salary of employee grouped by their department number.

Consider  this table --

You can understand by seeing this video ---

Answer =

SELECT Deptno , MAX(sal)  FROM EMPL GROUP BY Deptno ;

Deptno	Max(sal)
10	5000
20	3000
30	2850