MySQL Multi Row Subqueries Explained

Write a Query Using IN Operator

Write a MySQL query to find customers who have placed orders in any of the stores located in 'California'.

Expected output: List of customer names who placed orders in California stores.

Hint: Use a multi row subquery with IN to select store IDs in California.

Compare Prices Using ANY

Write a query to find products priced less than any product in category 10.

Expected output: List of product names priced less than at least one product in category 10.

Hint: Use the ANY operator with a subquery selecting prices from category 10.

Use ALL to Filter Suppliers

Find suppliers whose rating is greater than or equal to all suppliers in region 2.

Expected output: List of supplier names meeting the rating condition.

Hint: Use the ALL operator with a subquery selecting ratings from region 2.

A multi row subquery returns multiple rows of results and is used with operators like IN, ANY, or ALL to compare a value against multiple values.

Use IN when you want to check if a value matches any value in the list returned by the subquery.

ANY returns true if the condition matches at least one value in the subquery result, while ALL returns true only if the condition matches every value.