Consider the following table structure of employees: empid int(4) deptname varchar(50) salary int(4) Which query will be used to display the Department (deptname) that is giving the maximum salary? - Microsoft SQL Server

> > >

Microsoft SQL Server MCQs

Consider the following table structure of employees:

empid int(4)

deptname varchar(50)

salary int(4)

Which query will be used to display the Department (deptname) that is giving the maximum salary?

select deptname from employees where salary =max(salary)

select deptname from employees where salary =max(salary) group by deptname

select deptname from employees where salary = (select salary from employees group by salary)

select deptname from employees where salary =(select max(salary) from employees)

select deptname from employees where salary in (select salary from employees group by salary)

select deptname from employees where max(salary) in (select salary from employees group by salary)

Answer

Correct Answer: select deptname from employees where salary =(select max(salary) from employees)

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it