write a query to delete similar records in same table
Answer Posted / nirmalendu
delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name);
** column_name which having duplicate record
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
what is the difference between join and union? : Sql dba
What is rank function in sql?
How do you respond to dementia behavior?
What are the different types of joins in sql?
What is rank dense_rank and partition in sql?
Why do we need pl sql?
Why use triggers in sql?
What is pl/sql table? Why is it used?
How to read/write files from pl/sql?
When is the update_statistics command used?
What is nvarchar max in sql?
what are numeric data types? : Sql dba
What is auto increment in sql?
Why we use stored procedure instead of query?
what are the features and advantages of object-oriented programming? : Sql dba