Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 14731 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 sql in mysql? : Sql dba
Is primary key a clustered index?
How delete all records from table in sql?
What is partition by in sql?
what are the limitations of identity column? : Transact sql
What is schema in sql example?
What are the different parts of a package?
What is a function in oracle pl sql?
What are all the ddl commands?
What is the difference between pl and sql?
Can we use pl sql in sql server?
Is left join and outer join same?
How can you create an empty table from an existing table?
what are the types of subquery? : Sql dba
Explain the advantages and disadvantages of stored procedure?
