【SQL】多字段查找重复

最新推荐文章于 2025-02-10 21:33:18 发布

原创最新推荐文章于 2025-02-10 21:33:18 发布 · 4.2k 阅读

8 ·

CC 4.0 BY-SA版权

文章标签：

#sql #dba #数据库

SQL 专栏收录该内容

6 篇文章

订阅专栏

根据多个字段查找重复的数据

select 
  * 
from 
  table_test a 
where 
  (
    a.api_project_quota_id, 
    a.api_breed_id, 
    a.api_quota_id, 
    a.api_unit_id, 
    a.api_sample_id, 
    a.api_device_id
  ) in (
    select 
      api_project_quota_id, 
      api_breed_id, 
      api_quota_id, 
      api_unit_id, 
      api_sample_id, 
      api_device_id
    from 
      web_longzhong_data_diaoyan 
    group by 
      api_project_quota_id, 
      api_breed_id, 
      api_quota_id, 
      api_unit_id, 
      api_sample_id, 
      api_device_id
    having 
      count(*) > 1
  );