DELETE FROM EMP E1 WHERE ROWID< (SELECT MAX(ROWID) FROM EMP E2 WHERE E1

How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)

Question Posted / ravikumar2614

Answer Posted / ravikumar2614

DELETE FROM EMP E1 WHERE ROWID<
(SELECT MAX(ROWID) FROM EMP E2 WHERE E1.ROWID=E2.ROWID)

IF I AM WRONG PLEASE CORRECT ME ON ravi.info2614@gmail.com

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

generate date / time dimension in informatica

1082

Differentiate between source qualifier and filter transformation?

1525

Reusable transformation and shortcut differences

1799

Explain the difference between mapping parameter and mapping variable?

998

What are the components of workflow manager?

1036

What is transformation?

1061

Performance tuning in UNIX for informatica mappings?

2527

what is mean by complex business rule ?

2129

Differentiate between router and filter transformation?

967

What is the use of code page?

1030

What is deployment group?

1149

can you please explain me pre session and post session options?

7451

How do you manage the Parameter files while migrating your data from one environment to another environment?

978

What is joiner change?

1092

What is the difference between a connected look up and unconnected lookup?

924