Question

Arjun is using a table Employee. It has the following columns: 2

Code, Name, Salary, Deptcode

He want 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.

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

output.

b. Write the query to display the number of employees with same deptcode.​

Answer 1

Answer:

count(employee) is used to query the count of employees