In regards to sorting,if a DISTINCT option is used in the SELECT clause of a query then ____.
A) an ORDER BY clause can not be added
B) only columns in the SELECT clause can be used for sorting
C) only a primary sort is allowed
D) None of the above

Question

In regards to sorting,if a DISTINCT option is used in the SELECT clause of a query then ____.​
A) ​an ORDER BY clause can not be added
B) ​only columns in the SELECT clause can be used for sorting
C) ​only a primary sort is allowed
D) ​None of the above

Quizplus · Accepted Answer

When the DISTINCT option is used in the SELECT clause, only the columns listed in the SELECT clause can be used for sorting. Any other column(s) can't be used for sorting.

In Regards to Sorting,if a DISTINCT Option Is Used in the SELECT