In the office table, the city column is structured as shown:

Mysql> show columns from office like city'\G --------------------1. row --------------------- Field: city Type: enum(paris'.'Amsterdam'.'New York'.'Tokyo') Null: Yes Key:

Default:NULL Extra:

Consider the output of the SELECT query executed on the office table:

Mysql> SELECT DISTINCT city FROM office ORDER BY city:

If the query is written as:

SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR) In what order are the rows returned?

Question

In the office table, the city column is structured as shown:

Mysql> show columns from office like city'\G --------------------1. row --------------------- Field: city Type: enum(paris'.'Amsterdam'.'New York'.'Tokyo') Null: Yes Key:

Default:NULL Extra:

Consider the output of the SELECT query executed on the office table:

Mysql> SELECT DISTINCT city FROM office ORDER BY city:

If the query is written as:

SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR) In what order are the rows returned?

Accepted Answer

C. Amsterdam, New York, Paris, Tokyo

Answer

A. Paris, Amsterdam. New York, Tokyo

Answer

B. Tokyo, New York, Amsterdam, Paris

Answer

D. Tokyo, Paris, New York, Amsterdam

In the office table, the city column is structured as shown: Mysql> show columns from office like city'\G --------------------1. row --------------------- Field: city Type…

Question

Options

How the community answered

Community Discussion