一句SQL得出表中重复的数据(TMP) （转）

 

2008-05-13 11:19

select field1 from table1 group by field1 having count(field1) > 0