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

Difference between global and parameter variables?

1656

What has stored procedures in sql?

779

What is normalization in a database?

848

Define overloaded procedure?

803

How exception is different from error?

762

what are the advantages a stored procedure? : Sql dba

710

How do you update f as m and m as f from the below table testtable?

1467

What is the difference between alter trigger and drop trigger statements?

795

What does seeding a database mean?

689

What is the use of nvl function?

864

What is the max nvarchar size?

678

Is sql an operating system?

719

What is clause?

793

How many subqueries can be nested in a statement?

691

What is sql and its types?

817