Microsoft
98-361 · Question #149
In your student directory database, the Students table contains the following fields: - firstName - lastName - emailAddress - telephoneNumber You need to retrieve the data from the firstName…
The correct answer is D. Option D. to sort use: ORDER BY LastName, FirstName
Understanding Databases
Question
In your student directory database, the Students table contains the following fields:
- firstName
- lastName
- emailAddress
- telephoneNumber
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?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(59 responses)- A3% (2)
- B17% (10)
- C7% (4)
- D73% (43)
Explanation
to sort use: ORDER BY LastName, FirstName
Topics
#SQL SELECT#ORDER BY#data retrieval#SQL query
Community Discussion
No community discussion yet for this question.