根据4个字段,查表中所有4个字段相同的重复数据:
select
*
from
t_sale_task_market_rule_snapshot a #表名
where
(
# 需要被重复的字段
a.f_rule_id,
a.f_group_sequence,
a.f_rule_reach_type,
a.f_rule_sequence
) in (
select
f_rule_id,
f_group_sequence,
f_rule_reach_type,
f_rule_sequence
from
t_sale_task_market_rule_snapshot
group by
f_rule_id,
f_group_sequence,
f_rule_reach_type,
f_rule_sequence
having
count(*) > 1
);