consider the following table structure of employees empid int 4 deptname..., MS SQL Server 2005, Databases

MS SQL Server 2005

Test
- Model Test
Index

Question: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?

A select deptname from employees where salary =max(salary) 
B select deptname from employees where salary =max(salary) group by deptname 
C select deptname from employees where salary = (select salary from employees group by salary) 
D select deptname from employees where salary =(select max(salary) from employees) 
E select deptname from employees where salary in (select salary from employees group by salary) 
F select deptname from employees where max(salary) in (select salary from employees group by salary)

/76

+ AnswerD

+ Report

Descriptive on MS SQL Server 2005 Ebook

Total Preview: 613

Question: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?

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

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

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

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

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

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

D