Delete duplicate records in the emp table.
Answer Posted / amedela chandra sekhar
delete from emp x where rowid>(select min(rowid) from emp
where rmpno=x.empno);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is composite primary key in sql?
What are the advantages of stored procedure?
what are tables and fields? : Sql dba
What does an inner join do?
Explain the the delete statements in sql?
What is program debugging?
What is the difference between cross join and natural join?
Why do we use function in pl sql?
Can we write ddl statements in functions?
what is bcp? When is it used?
how to enter characters as hex numbers? : Sql dba
what is 'mysqlshow'? : Sql dba
How many types of tables are there?
Is grant a ddl statement?
What is pl sql script?