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?

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


mandisa

mandisa

A is the correct answer of which its sort by using Order By lastName, FirstName

DB7

DB7

A: contains proper fields, syntax and order