Which statement is true regarding the above query?

View the Exhibit and examine the data in the COSTS table.

You need to generate a report that displays the IDs of all products in the COSTS table whose unit
price is at least 25% more than the unit cost. The details should be displayed in the descending
order of 25% of the unit cost. You issue the following query:

Which statement is true regarding the above query?

View the Exhibit and examine the data in the COSTS table.

You need to generate a report that displays the IDs of all products in the COSTS table whose unit
price is at least 25% more than the unit cost. The details should be displayed in the descending
order of 25% of the unit cost. You issue the following query:

Which statement is true regarding the above query?

A.
It executes and produces the required result.

B.
It produces an error because an expression cannot be used in the ORDER BY clause.

C.
It produces an error because the DESC option cannot be used with an expression in the
ORDER BY clause.

D.
It produces an error because the expression in the ORDER BY clause should also be specified
in the SELECT clause.



Leave a Reply 1

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