数据库表数据查重

select count(*) from test_no_1 where test_not in (select test_not from test_no_1 group by test_not having count(*)>1);

test_no_1 是table_name
test_not是列名