View the Exhibit and examine the structure of the PRODUCTS table.
You want to display the category with the maximum number of items.
You issue the following query:
SQL>SELECT COUNT(*),prod_category_id
FROM products
GROUP BY prod_category_id
HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM products);
What is the outcome?
A.
It executes successfully and gives the correct output.
B.
It executes successfully but does not give the correct output.
C.
It generates an error because the subquery does not have a GROUP BY clause.
D.
It generates an error because = is not valid and should be replaced by the IN operator.
Nested query needs group by clause.
But in this case group by clause can’t be used with “-” sign.
Sorry, next comment should be
ut in this case group by clause can’t be used with “=” sign.
C is correct because you can’t nested aggregate function without a group by.
Yes.. it is right.
The correct systax could be the following:
SELECT COUNT(*, prod_category_id
FROM products
GROUP BY prod_category_id
HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM products
GROUP BY prod_category_id);
correcting….
SELECT COUNT(*),prod_category_id
FROM products
GROUP BY prod_category_id
HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM products GROUP BY prod_category_id);
B.
It executes successfully but does not give the correct output.
Yes Nested Group function most be have group by …
No es tan mala . emocionantes cosas aquí
http://www.opinionesdating.com/meetic-opiniones/
C