Compare Count From Outer SELECT in a Nested SELECT?

Question

I have this SQL Query,

select * from (select * from .......) as a
where 1 = case when CountOfInnerSelect = 1 Then 1 ELSE ............

Is it possible I can get Count of inner select inside the outer SELECT?

You can select the count from subquery then use it. SELECT a.Cnt, ... FROM (SELECT COUNT(1) as Cnt FROM ... WHERE ...) as a WHERE 1 = a.Cnt... You can do it without selecting it in your result. — Hamlet Hakobyan
– Hamlet Hakobyan, Commented Nov 26, 2012 at 9:06

Indi · Accepted Answer · 2012-11-26 09:09:45Z

1

Your WHERE Clause does not make much sense as it is applied like a filter here. (ie; similar to WHERE myCount = 1)

SELECT * FROM
(SELECT c1,c2,c3,..,Cn,COUNT(*) AS myCount
 FROM YourTable
 GROUP BY c1,c2,c3,..,Cn
) A
WHERE 1 = CASE myCount WHEN 1 THEN 1 ELSE... END

answered Nov 26, 2012 at 9:09

Indi

33.9k7 gold badges61 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jazzytomato · Accepted Answer · 2012-11-26 09:06:10Z

1

Yes :

select * from (select count(0) as cnt from .......) as a
where 1 = case when a.cnt = 1 Then 1 ELSE ............

answered Nov 26, 2012 at 9:06

jazzytomato

7,2593 gold badges33 silver badges44 bronze badges

1 Comment

Imran Qadir Baksh - Baloch Over a year ago

I need to select my coulmns in the inner select as well.

Collectives™ on Stack Overflow

Compare Count From Outer SELECT in a Nested SELECT?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related