[RESOLVED] mssql Just to make sure on having count

[sapator]

Hi.

ex1

select Idx from tblx
group by Idx 
having count(Idx )> 1

That works

ex2

select Idx,id2 from tblx
group by Idx,id2
having count(Idx)> 1

That does not work (no rows returned)

ex3

select Idx,id2,count(*) from tblx
group by Idx,id2
having count(*)> 1

That works

So am I do understand that ex2 will not work, unless I do something crazy like:

select s.Idx , t.Id2

from

(

select Idx

from tblx

group by Idx

having count(*) > 1

)s

join Idx t

on s.Idx= t.Idx

?