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;
View the Exhibit and examine the data in the DEPARTMENTS tables.Evaluate the following SQL statement:SELECT department_i
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am