Delete duplicate records in the emp table.
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 count * in sql?
How delete all records from table in sql?
What is clustered and nonclustered index in sql?
What is difference between procedure and trigger?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is compound trigger?
What is trigger and types?
what is log shipping? : Sql dba
what are the join types in tsql? : Transact sql
Is oracel sql developer written in java?
How would you convert date into julian date format?
What is the current version of postgresql?
What is flag in sql?
Can we call procedure in select statement?
How do I debug a stored procedure?