解决“子查询返回多于一行”错误的方法

=

当子查询返回的值大于1时，您将必须使用

IN

select * from tablewhere id IN (multiple row query);

例如：

SELECt *FROM StudentsWHERe Marks = (SELECt MAX(Marks) FROM Students)   --Subquery returns only 1 valueSELECt *FROM StudentsWHERe Marks IN       (SELECt Marks        FROM Students        ORDER BY Marks DESC       LIMIT 10) --Subquery returns 10 values