Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 14787 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / valli
delete from emp where rowid in(
select rowid from (
select emp_no, sal,rownum() over (emp_no,sal) as
Rownum from emp order_by emp_no,sal
) where rownum > 2
)
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is application trigger?
What is sequence in sql?
What is the cause of mutating table error and how can we solve it?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
Name the different types of indexes in sql and define them.
how to select unique records from a table? : Sql dba
what are the advantages a stored procedure? : Sql dba
Can you have a foreign key without a primary key?
Does group by remove duplicates?
What is the difference between subquery and correlated query?
How would you reference column values before and after you have inserted and deleted triggers?
Can I call a procedure inside a function?
define join and explain different type of joins? : Sql dba
What are the different parts of a package?
what are properties of a transaction? : Sql dba
