Subquery returns more than 1 row?

Question

[asdasdqwe]

возвращает ошибку: subquery returns more than 1 row?

Пока плохо знаю sql. где здесь ошибка?

DELETE FROM Orders
WHERE ProductId=(SELECT Id FROM Products WHERE ProductName='Galaxy S8');

Answer 1

[nozzy]

DELETE FROM Orders
WHERE ProductId=(SELECT Id FROM Products WHERE ProductName='Galaxy S8' LIMIT 1);