examine the data in employees table given below lastname departmentid salary allen..., MS SQL Server 2005, Databases

MS SQL Server 2005

Question:Examine the data in the EMPLOYEES table given below:

LAST_NAME  DEPARTMENT_ID  SALARY
Allen               10               3000
Miller               20               1500
King                20               2200
Davis               30                5000

Which of the following sub-queries work?

A SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id) 
B SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id) 
C SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id) 
D SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id) 
E SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY))

/76

+ AnswerC D

+ Report

Descriptive on MS SQL Server 2005 Ebook

Total Preview: 856

Question:Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY Allen 10 3000 Miller 20 1500 King 20 2200 Davis 30 5000 Which of the following sub-queries work?

A SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id)

B SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id)

C SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id)

D SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id)

E SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY))

C D