One way is to rename the original table to something else, and copy the un

write a query to delete similar records in same table

Question Posted / swapna

13 Answers
25435 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / swapna

One way is to rename the original table to something else,
and copy the unique records into the original table.

rename 'Table2', 'Table1'

select distinct * into Table2 from Table1

drop table1

Is This Answer Correct ?

5 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is it possible to pass parameters to triggers?

1159

What is sql exception?

1012

What is a trigger word?

1073

What is sqlerrd?

1011

What is dbo in sql?

1016

What is Histogram?

1608

How does join work in sql?

1050

What is the reports view in oracle sql developer?

1039

What is the difference between instead of trigger and after trigger?

1063

what is 'mysqlcheck'? : Sql dba

1063

What does <> sql mean?

1162

Does sql use python?

1090

What is procedure and function?

1033

what is 'mysqlshow'? : Sql dba

1073

Define sql delete statement.

1063