how to delete duplicate row from table?

Question

if table having same record then how to delete one of them

Answer 1

using distinct keyword u take only unique IDs

Answer 2

insert values into other new table by SELECT DISTINCT * FROM TABLE1 INTO newtable
then DELETE FROM TABLE1
then again insert dem back onto table1 from Newtable in similar fashion

Answer 3

by using distinct keyword we can do ......and another procedure also there like first we need to find out the duplicate records and then we need to remove them with the help of rownum .

Answer 4

delete from tbl1 a where rowid not in(select max(rowid) from tbl1 b where a.col1 = b.col1)---here col1 is the duplicate column....

Answer 5

use rowid for deletion of duplicate row

Answer 6

first alter to add use identity then use delete method this is possible I work out it

Answer 7

use delete from then select which table(Id) you want to delete.