Which two statements are true regarding the ORDER BY clause?

Which two statements are true regarding the ORDER BY clause? (Choose two.)

Which two statements are true regarding the ORDER BY clause? (Choose two.)

A.
It is executed first in the query execution.

B.
It must be the last clause in the SELECT statement.

C.
It cannot be used in a SELECT statement containing a HAVING clause.

D.
You cannot specify a column name followed by an expression in this clause.

E.
You can specify a combination of numeric positions and column names in this clause.



Leave a Reply 1

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


Hola

Hola

ORDER BY
CAST(SUBSTRING(issue, 1, 4) AS INT) DESC, — Year

E is right