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

Explain the order of sql statement execution?

834

Is left join faster than inner join?

900

What is a crud api?

725

How do I create a sql script?

839

What are different joins used in sql?

815

How do you take the union of two tables in sql?

773

Enlist some predefined exceptions?

832

Who developed sql?

811

What does over partition by mean in sql?

745

What are crud methods?

795

What are the properties of a transaction?

885

explain the difference between myisam static and myisam dynamic. : Sql dba

744

How to sort the rows in sql.

861

What are the operators in sql?

806

How does sql developer connect to oracle database?

784