sql 语句中的常见问题（持续更新~）

Error 1:

Subquery returns more than 1 row

看下面的sql语句

SELECT DISTINCT s.`studentno`,`studentname`
FROM `student` AS s INNER JOIN `result` AS r
ON s.`studentno`=r.`studentno`
WHERE `studentresult`>=85 AND `subjectno`  =
(
 SELECT `subjectno` FROM `subject` 
 WHERE `subjectname` ='C语言-1'
);

---

报错！

Subquery returns more than 1 row

这里指子查询的结果多于一行，即我们子查询结果无法于子查询的范围相匹配

---

解决方式： 将搜索范围扩大 where subjectno = 改为 where subjectno in (…)