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
Explanation:
to sort use: ORDER BY LastName, FirstName
A is the correct answer of which its sort by using Order By lastName, FirstName
A: contains proper fields, syntax and order