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 are data types in pl sql?

826

Why stored procedure is better than query?

720

How to look at the current sql*plus system settings?

784

What is restrict in sql?

782

What is sql integrity?

809

How many scalar data types are supported in pl/sql?

748

What types of commands can be executed in sql*plus?

814

What are the packages in pl sql?

780

What are the parameter modes supported by pl/sql?

763

What type of join is sql join?

733

describe mysql connection using mysql binary. : Sql dba

778

Is pl sql useful?

742

What is nested table in pl sql?

779

What is sql catalog?

800

What is sequence in sql?

758