Answer 1

follow the link. there some possibilities are described

http://www.besttechtools.com/articles/article/sql-query-to-delete-duplicate-rows

Answer 2

You want to actually ALTER the table or just display the unique records only? For the former, you may take Oliver's suggestions.
For the latter SELECT DISTINCT should do the trick.