Which two ORDER BY clauses can be used to sort the output of the above statement?

View the Exhibit and examine the data in the DEPARTMENTS tables.

Evaluate the following SQL statement:
SELECT department_id “DEPT_ID”, department_name , ‘b’
FROM departments
WHERE department_id=90
UNION
SELECT department_id, department_name DEPT_NAME, ‘a’
FROM departments
WHERE department_id=10
Which two ORDER BY clauses can be used to sort the output of the above statement? (Choose
two.)

View the Exhibit and examine the data in the DEPARTMENTS tables.

Evaluate the following SQL statement:
SELECT department_id “DEPT_ID”, department_name , ‘b’
FROM departments
WHERE department_id=90
UNION
SELECT department_id, department_name DEPT_NAME, ‘a’
FROM departments
WHERE department_id=10
Which two ORDER BY clauses can be used to sort the output of the above statement? (Choose
two.)

A.
ORDER BY 3;

B.
ORDER BY ‘b’;

C.
ORDER BY DEPT_ID;

D.
ORDER BY DEPT NAME;



Leave a Reply 0

Your email address will not be published. Required fields are marked *