PrepAway - Latest Free Exam Questions & Answers

Which SQL statement must be executed?

If the following result set is desired: Which SQL statement must be executed?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH
FIRST 5 ROWS

B.
SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5
ROWS

C.
SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH

FIRST 5 ROWS ONLY

D.
SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5
ROWS ONLY


Leave a Reply