hard20 pts · first answer countssqlsubqueries

Subquery returns more than one row

This query worked last month but now fails with "more than one row returned by a subquery used as an expression". What changed?

A.The orders table now has a NULL amountB.Some customer now has two or more ordersC.A customer was deleted from the tableD.The subquery now needs a GROUP BY on c.name

Discussion 0

Join free to post in the discussion.

Subquery returns more than one row

Discussion 0

Related questions