Delete duplicate records in the emp table.
- 6 Answers
- 13694 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / smriti
delete from tablename a where a.rowid>(select min(rowid)
from tablename b where a.columnname=b.columnname)
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
I need a function for a train ticket reservation please answer it thanks in advance
Why do we use sqlite?
What are triggers and its types?
What is an emotional trigger?
Write the alter statement to enable all the triggers on the t.students table.
Explain alias in sql?
What are the different sql commands?
What is a join?
Can we use ddl statements in stored procedure sql server?
What are the types pl/sql code blocks?
What are the different schemas objects that can be created using pl/sql?
When is the update_statistics command used?
What is dml and ddl?
explain the difference between delete , truncate and drop commands? : Sql dba
What is benefit of creating memory optimized table?
