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

What do mean by local and global repository?

1198

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2018

Explain how to import oracle sequence into informatica?

985

How to generate or load values in to the target table based on a column value using informatica etl tool.

1049

which one is better performance wise joiner or look up

1067

When do you use sql override in a lookup transformation?

1076

In how many ways we can create ports?

1106

What does cheating measurement mean?

1030

Separate from an archive server and a powerhouse?

941

What is expression transformation?

1081

What is union transformation in informatica?

1131

Enlist some properties of sessions.

1053

Explain in detail scd type 2 through mapping.

1025

Explain where to store informatica rejected data? How to extract the informatica rejected data?

993

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1106