Gopi Krishna is using a table Employee. It has the following columns:Code, Name, Salary, Deptcode

Q. Gopi Krishna is using a table Employee. It has the following columns:

Code, Name, Salary, Deptcode

He wants to display maximum salary department wise. He wrote the following command:

SELECT Deptcode, Max(Salary) FROM Employee ;

But he did not get the desired result.

Rewrite the above query with necessary changes to help him get the desired output.

Answer :-

SELECT Deptcode, Max(Salary)

FROM Employee

GROUP BY Dept Code;