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 constant in pl sql?

970

What is forward declaration in pl sql?

1008

How do you copy a table in sql?

1015

Explain the purpose of %type and %rowtype data types with the example?

929

What is a behavioral trigger?

932

What is the use of desc in sql?

916

What is difference between joins and union?

1046

What is before and after trigger?

894

which operator is used in query for pattern matching? : Sql dba

950

What is the difference between unique and primary key constraints?

1010

How do sql triggers work?

989

What are the subsets of sql?

1038

What are literals in sql server?

1075

What is the purpose of the partition table?

1003

What is sql architecture?

985