MCQs > IT & Programming > ASP.NET With SQL Server > Which of the following Subqueries will execute without any error?

ASP.NET With SQL Server MCQs

LAST_NAME  DEPARTMENT_ID     SALARY
ALLEN                10                      3000
MILLER              20                     1500
King                   20                      2200
Davis                 30                      5000

Which of the following Subqueries will execute without any error?

Answer

Correct Answer: SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

Explanation:

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

ASP.NET With SQL Server Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

More ASP.NET With SQL Server MCQ Questions

search

ASP.NET With SQL Server Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it