View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.) Examine this SQL statement:

SELECT department_id "DEPT_ID", department_name, 'b' FROM departments WHERE departments_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?

Question

View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.) Examine this SQL statement:

SELECT department_id "DEPT_ID", department_name, 'b' FROM departments WHERE departments_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?

Accepted Answer

B. ORDER BY DEPT_ID; D. ORDER BY 3;

Answer

A. ORDER BY DEPT_NAME;

Answer

C. ORDER BY 'b';

View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.) Examine this SQL statement: SELECT department_id "DEPT_ID", department_name, 'b' FROM departments WHERE…

Question

Options

How the community answered

Community Discussion