Home Forums SQL Server 2008 SQL Server 2008 - General Ranking Query RE: Ranking Query
Anjan@Sql
SSCrazy
Points: 2316
More actions
April 16, 2013 at 12:05 am
#1606700
Select Name,COUNT(distinct id)
from @table
group by name
having COUNT(distinct id) =3