write a query to delete similar records in same table
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 |
Post New Answer View All Answers
What are the packages in pl sql?
What port does sql server use?
Why use stored procedures?
What is join view in sql?
What is sql character function?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
How can we implement rollback or commit statement in a trigger?
Why do we use view in sql?
How does a trigger work?
Can ddl statements be used in pl/sql?
When is a declare statement required?
How can we link a sql database to an existing android app?
Where is all the data on the internet stored?
What is a database event trigger?
Name the different types of indexes in sql and define them.