Examine the description of the members table:

Examine the partial query:

SELECT city, last__name 1NAME FROM members You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order. Which two clauses must you add to the query?

Question

Examine the description of the members table:

Examine the partial query:

SELECT city, last__name 1NAME FROM members You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order. Which two clauses must you add to the query?

Accepted Answer

A. ORDER BY 1, LNAME DESC C. WHERE city LIKE *%AN%*

Answer

B. ORDER BY 1, 2

Answer

D. WHERE city = =%AN%'

Answer

E. WHERE city IN (?AN%')

Answer

F. ORDER BY last_narae DESC, city ASC

Examine the description of the members table: Examine the partial query: SELECT city, last__name 1NAME FROM members You want to display all cities that contain the string an. The cities must be…

Question

Exhibit

Options

How the community answered

Topics

Community Discussion