SELECT id,count(1) FROM tbl_table GROUP BY id HAVING count(1) > 1
SQL查询数据是否重复
最新推荐文章于 2023-12-14 15:26:22 发布
SELECT id,count(1) FROM tbl_table GROUP BY id HAVING count(1) > 1