重复数据查询:
SELECT * FROM user t WHERE t.user_id IN
(SELECT t.user_id FROM user t GROUP BY t.user_id HAVING count() > 1); --查询表中某一个字段重复的数据
查询数据量:
SELECT COUNT() FROM user a WHERE a.user_id = 2027983614;
oracle 查询表中某一个字段存在重复的数据
最新推荐文章于 2024-04-27 17:30:34 发布