就是说数据库中有多条记录，找表其中两个字段都相同的项目。
table name : table1
id name age
就是找其中name和age都是相同的内容！
---------------------------------------------------------------
select name,age from table1 group by name,age having count(*) > 1
---------------------------------------------------------------
SELECT * FROM table1 a WHERE EXISTS (SELECT * FROM table1 b WHERE a.name=b.name and a.age=b.age GROUP BY name,age HAVING COUNT(*) > 1 ) ORDER BY name,age
---------------------------------------------------------------
select name,age,min(id) from tabke1 group by name,age
---------------------------------------------------------------
select a.name,a.age,max(a.id) as id from (select * from #temp where name=age) as a
group by a.age,a.name