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

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1271

How many primary keys can a table have?

1013

Can %notfound return null after a fetch?

1064

How do you copy a table in sql?

1076

Differentiate pl/sql and sql?

1071

Is merge a dml statement?

984

What is clause?

1158

What is record in pl sql?

1090

Can we commit inside a trigger?

998

What is pl sql variable?

998

Explain the significance of the & and && operators in pl sql.

1010

Which are the different character-manipulation functions in sql?

1071

What is difference between pls_integer and integer?

969

How to display the current date in sql?

1084

Define join and name different types of joins?

1008