delete from sampletable where ids in(select ids from sampletable group

write a query to delete similar records in same table

Question Posted / balaji

Answer Posted / balaji

delete from sampletable where ids in(select ids from
sampletable group by ids having count(ids)>1)

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the best sql course?

976

what is datawarehouse? : Sql dba

1007

Can you do multiple joins in sql?

1040

what is primary key? : Sql dba

1019

What is sql not null constraint?

1023

How to make a copy values from one column to another in sql?

1030

Explain the insert into statements in sql?

999

How can you create an empty table from an existing table?

1068

What is trigger in flip flop?

1007

What is nvarchar in sql?

921

what are the security recommendations while using mysql? : Sql dba

1111

Explain mutating table error.

1193

What are predefined functions in sql?

1040

Does oracle roll back the transaction on an error?

1006

how to rename an existing column in a table? : Sql dba

1015