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 are the types of join and explain each?

1053

What are all the different types of indexes?

1152

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1018

How would you pass hints to the sql processor?

986

What is the difference between left and left outer join?

950

What are pl sql procedures?

1032

Do we need to rebuild index after truncate?

1037

What is rtm in testing?

1121

What do you understand by pl/sql cursors?

1092

Explain the methods used to protect source code of pl/sql.

1029

What is date functions?

1036

What is flag in sql?

1040

Is natural join and inner join same?

932

What is pl sql and why it is used for?

1114

How to handle bulk data?

1318