databases Online Quiz - 98
Casual Mode - Take your time!
1 / 20
Correct
0
Incorrect
0
Score
0%
Multiple Choice
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC;
- The two statements produce identical results.
- The second statement returns a syntax error.
- There is no need to specify DESC because the results are sorted in descending order by default.
- The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.