查找某字段记录相同的所有记录,怎么写那句话?

[getgoodgift]

就是把所有某字段记录重复的记录都查找出来,怎么写?

[sasacat]

SELECT b, count(1)
FROM t1
GROUP BY b
having count(1) >1

[yzssg]

select * from table1 where yourField in (select yourField from table1 group by yourField having count(yourField)>1)

[dafu71]

select yourField,count(yourField) 重复数 from table1 group by yourField having count(yourField)>1