Which clause in the above SQL statement causes the error?

View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement:

The above query generates an error on execution.
Which clause in the above SQL statement causes the error?

View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement:

The above query generates an error on execution.
Which clause in the above SQL statement causes the error?

A.
WHERE

B.
SELECT

C.
GROUP BY

D.
ORDER BY



Leave a Reply 3

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


reach

reach

Alias Name cannot be used in “Groupby” clause. But can be used in “order by” clause.

kabelo

kabelo

I think is more a case of grouping by the wrong column. Even if the alias was not used and we grouped by promo_cost it would still be an error. We have to group by the non aggregated column = promo_category…am i right?