在查询结果中查询 查询结果放到临时表中, 在临时表中查询. select count(*) as c, gameserverid into #tmp from gms_data group by [filename], gameserverid having count(*) > 1select * from #tmp