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 commit and rollback in mysql : sql dba

1073

Does sql support programming?

1115

what are the limitations of identity column? : Transact sql

1160

Which join is default?

1012

How does stored procedure reduce network traffic?

1064

Explain ddl statements in pl/sql?

1051

What is pl sql architecture?

999

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1131

What are the popular database management systems in the it industry?

1035

how to convert numeric values to character strings? : Sql dba

1156

What is difference between stored function and application function?

1288

what is the difference between where clause and having clause? : Sql dba

1044

Is primary key is clustered index?

1041

What is procedure explain with program?

1066

What is sql character function?

1148