What is a Row Subquery?
Returns one row with multiple values.
Example: Getting min and max price in one subquery.
Basic Example
SELECT *
FROM products
WHERE (price, stock) = (SELECT MAX(price), MAX(stock) FROM products);Finds product with highest price AND highest stock.
Summary
Row subquery = Returns one row, multiple columns Less common than scalar or column subqueries