Which statement should you use?

In your student directory database, the Students table contains the following fields:

firstName

lastName

emailAddress

telephoneNumtoer

You need to retrieve the data from the firstName, lastName, and emailAddress fields for all students listed in the directory. The results must be in alphabetical order according to lastName and then firstName.

Which statement should you use?

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: A

Explanation:

to sort use: ORDER BY LastName, FirstName