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
select top 10 * from [Table] group by [ID] having count(*)>2
I need to return all the rows of ID=1