sqlserver查找一张表中某一字段相同的数据

可使用如下语句，其中col 为重复值的字段名

select * from t where col in(select col from t as t2 group by col having count(*) > 1);

------简易版-----

查询一张表中某一字段重复的个数

SELECT count(person_id) as num ,person_id from fa_bi_person  GROUP BY person_id