我希望在数据库中查找重复记录,并显示所有重复记录。我的当前查询语句如下:
SELECT 'duplicate' as dup,c.Id, c.CreatedDate, c.email, c.Lead_Grade__c, count(c.email)
FROM contact as c
Inner Join (select c.Id, c.email FROM contact as c group by c.email having count(c.email) > 1) as dup
ON c.email = dup.email
WHERE Lead_Grade__c is null;
这个方法可以为每个重复的记录提供1行。我希望每个重复的记录都有2行(或更多)。因此,如果记录X和记录Y都具有相同的电子邮件,则我想显示两者。
有什么想法吗?
谢谢!