Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.-HiError

错误异常>数据库>Sql Server

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Sql Server子查询

其他环境

￥10.00

程序里面SQL Server 2012抛出的异常，看不懂，也不知道怎么解决：Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

始于初秋 T0 采纳率50%

+ 我有其他方法

最佳答案

原因分析

子查询返回多个结果了

select *,

(select ID from t2 where t1.ID=t2.t1ID)

from t1

你的语句应该跟这个差不多

改成

select *,

(select top 1 ID from t2 where t1.ID=t2.t1ID)

from t1

即可

Yanne T2 被采纳率86%

2020-12-07 16:27

打赏

页面统计

166 访问

1 帮助

0.00 打赏

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

最佳答案

关注公众号，接受最新回答的通知