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

Does sql require a server?

994

how do you know if your mysql server is alive? : Sql dba

1062

what is transaction? : Sql dba

988

Does varchar need length?

978

Is primary key a clustered index?

958

Can we join same table in sql?

993

What is rownum?

963

What is the difference between count 1 and count (*) in a sql query?

962

Are subqueries faster than joins?

992

What are the triggers associated with image items?

1030

difference between anonymous blocks and sub-programs.

1119

What is db journal file?

1033

What does the base_object_type column shows in the user.triggers data dictionary view?

1029

what are string data types? : Sql dba

1019

What is pl sql package?

1021