我收到错误“当未使用EXISTS引入子查询时，只能在选择列表中指定一个表达式。 [英] i am getting error " Only one expression can be specified in the select list when the subquery is not introduced with EXISTS."

问题描述

我有一个选择查询

i have one select query

select ROW_NUMBER()over( order by university_info.university_id)as srno, university_id, university_name from university_info where organization_id='02' and
(university_id not in (select directors, university_id from state_visit_info where organization_id='02'))

$ b $我得到的错误就像只有一个表达式可以当子查询没有引入EXISTS时，在选择列表中指定。



如何解决这个问题

i am getting error like " Only one expression can be specified in the select list when the subquery is not introduced with EXISTS."

how to solve this problem

推荐答案

你不能在子子查询中返回两列进行比较，更改

you can't return two columns in your sub subquery to do a comparison, change

(select directors, university_id from state_visit_info where organization_id='02')

to

to

(select university_id from state_visit_info where organization_id='02')

你在子查询中写了两个字段

you have wrote two fields in sub query

select directors, university_id from state_visit_info where organization_id='02'

只写一个字段

write only one field

university_id 

像这样.. :)

like this.. :)

select ROW_NUMBER()over( order by university_info.university_id)as srno, university_id, university_name from university_info where organization_id='02' and
(university_id not in (select university_id from state_visit_info where organization_id='02'))

注意：只有我给你的基本逻辑.....你必须修改它根据您的需要



问候，

Nirav Prabtani

这篇关于我收到错误“当未使用EXISTS引入子查询时，只能在选择列表中指定一个表达式。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！