[导入]例子:查找字段相同的语句

select * from [TableName] group by pID HAVING COUNT(*)>1 order by tID desc
文章来源:http://Jorkin.Reallydo.Com/default.asp?id=379