delete from emp where rowid not in (select max(rowid)

write a query to delete similar records in same table

Question Posted / kirankumar.vangeti

Answer Posted / kirankumar.vangeti

delete from emp
where rowid not in (select max(rowid)
from emp
group by emp_number);

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is linq to sql?

770

how many columns can be used for creating index? : Sql dba

673

What is an oracle stored procedure?

784

How we can update the view?

811

What is the trigger in sql?

700

Explain cursor types?

750

Is sql a oracle?

698

What is the purpose of cursors in pl/sql?

798

What does sql stand for?

702

How do you write an index?

703

How exception handling is done in advance pl/sql?

672

Is trigger a stored procedure?

700

What is a procedure in pl sql?

780

What is primary key and foreign key?

717

what is 'trigger' in sql? : Sql dba

726