DELETE FROM EMP E1 WHERE ROWID <(SELECT MAX(ROWID) FROM EMP E2 WHERE E1

write a query to delete similar records in same table

Question Posted / raj

Answer Posted / raj

DELETE FROM EMP E1
WHERE ROWID <(SELECT MAX(ROWID) FROM EMP E2 WHERE E1.ENO =
E2.ENO)

Is This Answer Correct ?

25 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is pivot table in sql?

1107

What is right join sql?

964

What is sqlexception in java?

990

Why indexing is needed?

984

What is a natural join?

1070

What is the purpose of design view?

1007

What does bitemporal mean?

1065

What is varray in pl sql?

1075

What is java sql drivermanager?

1093

Explain foreign key in sql?

1022

What does count (*) do in sql?

1012

What is database sql?

1051

what is the use of set statement in tsql? : Transact sql

1011

What are the two types of exceptions in pl/sql?

1052

Can we use ddl commands in pl sql?

1162