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 a primary key? : Sql dba

742

What is cte sql?

716

What is scalar and vector?

720

What are properties of the transaction?

723

Does pl sql work in mysql?

684

Are dml statements autocommit?

748

What is program debugging?

761

What is multiple partition?

692

what is a database? : Sql dba

808

What is a crud api?

681

Which is faster subquery or join?

848

Why is sql important?

758

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

722

What is a sql profiler?

769

What are the different tcl commands in sql?

815