Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for how to eliminate the duplicate rows
without using distinct?
- 6 Answers
- 12363 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / czarabid
it's very simple the question is to delete the duplicated
records and it's solution is here
DELETE FROM TABLE_NAME1 t1 WHERE ROWID </> any(SELECT ROWID
FROM TABLE_NAME1 t2 WHERE t1.column1=t2.column1);
this will delete only the redundant records leaving only one
copy of the same records in the table.
If you want to delete all the records which are redundant
then the solution is here
DELETE from table_name1 t1 where rowid <> any (select rowid
from table_name1 t2 where t1.no=t2.no)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between joiner and lookup transformation?
Design a mapping to load a target table with the following values from the above source?
What are the new features of informatica 9.x in developer level?
What is the use of transformation?
In development project what is the process to follow for an etl developer from day1
Explain in detail about scd type 1 through mapping.
What are the settings that you use to configure the joiner transformation?
Why update strategy and union transformations are active? Explain with examples.
What are the new features of informatica 9.x at the developer level?
How can we use mapping variables in informatica? Where do we use them?
How can you increase the performance in joiner transformation?
Explain the mapping variable usage example in informatica
How can we delete duplicate rows from flat files?
How to extract the informatica rejected data?
what is Active lock explain
