子查询 Subquery returns more than 1 row

当你的子查询返回多于一行的结果时，会出现"Subquery returns more than 1 row"的错误。这个错误说明你的子查询的筛选条件导致了多行结果。解决这个问题的方法是检查子查询的筛选条件，确保它只返回一行结果。你可以单独执行子查询，并排查错误所在。你可以尝试使用GROUP BY和HAVING子句来限制子查询的结果行数，以确保只返回一行结果。例如，你可以使用类似以下的查询语句来解决这个问题：

EXPLAIN select * from mytable where shouji = (select shouji from mytable GROUP BY shouji HAVING count(shouji)>2)

这样的查询会返回一个错误信息，其中会指出具体的错误行数和错误类型。你可以根据这些信息对子查询进行调试，并修复筛选条件，确保只返回一行结果。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [mysql报错：子查询返回值大于一](https://blog.csdn.net/azure10492/article/details/126031336)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *3* [关于mysql错误：Subquery returns more than 1 row](https://blog.csdn.net/zuihongyan518/article/details/82967902)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]