Hello!
I can't get around the 'having' statement, can you tell me please why the below does not work?
ID, Col1, Col2
1, A, C
1, B, D
2, E, F
3, G, H
etc
select top 10 *
from [Table]
group by [ID]
having count(*)>2
I need to return all the rows of ID=1
Thanks!