Sign Up ›
  • Dev org 83
  • NEWBIE
  • 0 Points
  • Member since 2021
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
2 replies

get count of duplicate contact name and one of duplicate contact id

The requirement is to get the all duplicate contact with firstname,email,Id, duplicate count

I have already tried this method 
[SELECT FirstName,LastName,Email, count(Id) tduplicates FROM Contact GROUP BY FirstName,LastName,Email HAVING count(Id)>1]

but it didn't give the Id

please help me out here