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 %type and %rowtype for?

1106

Explain unique key in sql.

1060

What is Difference Between Unique and Primary Key Constraints?

1153

Is join an inner join?

1021

Differentiate between sga and pga.

1206

How do I view output in sql developer?

1122

What are the set operators in sql?

1136

how to write date and time literals? : Sql dba

1010

Why truncate is used in sql?

1043

what are the authentication modes in sql server? : Sql dba

1118

What is the plv (pl/vision) package offers?

1112

Can we commit in trigger?

1027

Can a key be both primary and foreign?

1053

What are the two different parts of the pl/sql packages?

1138

What is delimiter in pl sql?

1098