MCQs > IT & Programming > Adobe ColdFusion > Examine the data in the EMPLOYEES table given below: LAST_NAME DEPTARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following queries will execute without error?

Adobe ColdFusion MCQs

Examine the data in the EMPLOYEES table given below:

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


Which of the following queries will execute without error?



Answer

Correct Answer: cfquery name="GetEmpInfo" datasource="myDSN"SELECT distinct department_id FROM employees Where salary IN (SELECT AVG(salary) FROM employees GROUP BY department_id)/cfquery

Explanation:

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

Adobe ColdFusion Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Adobe ColdFusion Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it