What is the outcome the following query?

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?

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.



Leave a Reply 10

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


Bina

Bina

Nested query needs group by clause.
But in this case group by clause can’t be used with “-” sign.

Bina

Bina

Sorry, next comment should be
ut in this case group by clause can’t be used with “=” sign.

DD

DD

C is correct because you can’t nested aggregate function without a group by.

Prince jain

Prince jain

Yes.. it is right.

Sayed

Sayed

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);

Sayed

Sayed

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);

Hossam

Hossam

B.
It executes successfully but does not give the correct output.

Hossam

Hossam

Yes Nested Group function most be have group by …