If the following result set is desired:
Which SQL statement must be executed?
A.
SELECT lastname, firstnme, salary, job
FROM employee
ORDER BY 3
FETCH FIRST 5 ROWS ONLY
B.
SELECT lastname, firstnme, salary, job
FROM employee
ORDER BY 3 DESC
FETCH FIRST 5 ROWS ONLY
C.
SELECT lastname, firstnme, salary, job
FROM employee
ORDER BY 3
FETCH FIRST 5 ROWS
D.
SELECT lastname, firstnme, salary, job
FROM employee
ORDER BY 3 DESC
FETCH FIRST 5 ROWS
Explanation: