The following SQL statement contains which type of subquery?
SELECT title,retail,category FROM books
WHERE retail IN (SELECT MAX(retail)FROM books
GROUP BY category);
A) single-row
B) multiple-row
C) multiple-column
D) correlated

Question

The following SQL statement contains which type of subquery?
SELECT title,retail,category FROM books
WHERE retail IN (SELECT MAX(retail)FROM books
GROUP BY category);
A) ​single-row
B) ​multiple-row
C) ​multiple-column
D) ​correlated

Quizplus · Accepted Answer

The subquery in this SQL statement returns multiple rows (the maximum retail price for each category), hence it is a multiple-row subquery.

The Following SQL Statement Contains Which Type of Subquery