Microsoft
98-361 · Question #34
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, lastNam
The correct answer is A. Option A. 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
- 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?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(25 responses)- A72% (18)
- B16% (4)
- C4% (1)
- D8% (2)
Explanation
to sort use: ORDER BY LastName, FirstName
Topics
#SELECT statement#ORDER BY#SQL query#data retrieval
Community Discussion
No community discussion yet for this question.