Subquery returns more than 1 row表示子查询返回了多行数据
例如:
select * from table1 where table1.colums=(select columns from table2)
解决方法
select * from table1 where table1.colums=any(select columns from table2)
2024-03-07 11:25:26
Subquery returns more than 1 row表示子查询返回了多行数据
例如:
select * from table1 where table1.colums=(select columns from table2)
解决方法
select * from table1 where table1.colums=any(select columns from table2)