Duplicate Record removal

How can I remove duplicate data easily? I have a large amount of duplicate rows after a row import