根据多个字段查找重复的数据
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
);