PrepAway - Latest Free Exam Questions & Answers

Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME,

Given the following query:
SELECT last_name, first_name, age, hire_date

FROM employee
WHERE age > 40
Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and
by LAST_NAME, from A to Z?

PrepAway - Latest Free Exam Questions & Answers

A.
SORT BY age ASC,last_name

B.
SORT BY age DESC,last_name

C.
ORDER BY age DESC,last_name

D.
ORDER BY age ASC,last_name

One Comment on “Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME,


Leave a Reply