Subquery returns more than 1 row?

Question

SQL

returns error: subquery returns more than 1 row?

I don't know much about sql yet. where is the error here?

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

Answer 1

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