run this sql query:

select distinct * from

now save the result returned by the query as a table and name it table1

drop the exixting table having duplicate rows and...