查询某一字段是不是重复

分类: IT文章 • 2023-11-01 12:23:39

查询某一字段是否重复

select lu.user_name, count(*) cc
            from qx.leap_user lu
           group by lu.user_name
          having count(*) > 1