View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?

Question

Admin · Accepted Answer

The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement.

Admin · Answer

The statement would execute successfully and display all the rows in the ascending order ofDEPARTMENT_ID.

Admin · Answer

The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order.

Admin · Answer

The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause.

Discusssion