Which SQL statement must be executed?

seenagapeMarch 24, 2014

If the following result set is desired:

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:

Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions