Find nodes with duplicate properties

gistfile1.txt

// Replace <INDEX> and <PROPERTY>


START n=node:<INDEX>('*:*')
WITH n
ORDER BY id(n) DESC  // Order by descending to delete the most recent duplicated record
WITH n.<PROPERTY>? as DuplicateKey, COUNT(n) as ColCount, COLLECT(id(n)) as ColNode
WITH DuplicateKey, ColCount, ColNode, HEAD(ColNode) as DuplicateId
WHERE ColCount > 1 AND (DuplicateKey is not null) AND (DuplicateId is not null)
WITH DuplicateKey, ColCount, ColNode, DuplicateId 
ORDER BY DuplicateId 
RETURN DuplicateKey, ColCount, DuplicateId