View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statements:
What will be the result?
Exhibit 1.
Exhibit 2.
A. It gives an error because the GROUP BY clause is not valid
B. It executes successfully but does not give the required result
C. It executes successfully and gives the required result
D. It gives an error because the ALL keyword is not valid
B is the correct ans
<ALL means less than the lowest value returned by subquery.
To get the required result you need to use ANY instead of ALL
Answer: B
Kate I am studying for SQL exam and I find all of your answer correct most of the time. Thank you so much.
I think B…