在查询结果中查询

查询结果放到临时表中, 在临时表中查询. 

select count(*) as c, gameserverid into #tmp from gms_data  

group by [filename], gameserverid having count(*) > 1

select * from #tmp