Select single column from a sub query returning multiple columns

Question

This is my query

select *
from table  
where a in (select a,b,count(*) from table where b= 99991231 group by 1,2 having count(*) > 1)  ;

ERROR 4829:  Subquery has too many columns

I want to select those values of a where b's value is 99991231 and is repeated more than one

You are projecting three columns in your subquery, but comparing a single one of them in the IN clause. Select — iamsankalp89, Sep 27 '17 at 07:47

score 1 · Answer 1 · answered Sep 27 '17 at 07:48

1

Without subquery you can write it as

select a
from table 
where b= 99991231 
group by a
having count(*) > 1

answered Sep 27 '17 at 07:48

M Khalid Junaid

63,861
10
90
118

Select single column from a sub query returning multiple columns

1 Answers1