pgsql表中查询重复数据

时间：2025-7-11 作者：网络剑客 分类： mysql

SELECT DISTINCT *
FROM (
    SELECT *, COUNT(*) OVER (PARTITION BY user_name) as cnt
    FROM user_a8
) as subquery
WHERE cnt > 1 ORDER BY user_name;