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 stored procedure? : Sql dba

1056

What are analytic functions in sql?

973

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

946

what is primary key? : Sql dba

957

Enlist some predefined exceptions?

999

Which is better stored procedure or query?

922

what is a trigger? : Sql dba

976

What are the advantages of pl sql?

1074

What is bind reference and how can it be created?

968

What is the purpose of a sql?

915

What is a clob in sql?

969

How do you truncate?

855

Can we join same table in sql?

964

How to select unique records from a table?

1003

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1007