Delete duplicate records in the emp table.
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
What is a full join sql?
what are the advantages and disadvantages of views in a database? : Sql dba
What is auto increment in sql?
what is a unique key ? : Sql dba
what are the advantages of using stored procedures? : Sql dba
Can we create a trigger on view?
Can a foreign key be a duplicate?
Can we insert in sql function?
how to drop an existing table in mysql? : Sql dba
Is sql a case sensitive language?
How do you change a value in sql?
Define tables and fields in a database
What is data modelling in sql?
what are rollup and cube in t-sql? : Transact sql
Explain cursor types?