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 are the different sql languages?

1090

what is uncommittable transactions? : Transact sql

1036

What are synonyms in sql?

1018

How to change sql*plus system settings?

1104

What is posting?

1083

What is java sql connection?

1120

Can we enter data in a table in design view?

1011

What is the clause we need to add in function body to return variable?

1051

what is the difference between undefined value and null value? : Sql dba

1140

Can a foreign key be null?

1142

What are the operators in sql?

1067

what is sql server agent? : Sql dba

1156

What is the use of triggers?

1082

Explain the uses of control file.

1098

Is ms sql traffic encrypted?

960