write a query for how to eliminate the duplicate rows
without using distinct?
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
what is mean by complex business rule ?
What are the advantages of informatica?
What are roles and groups and benefits of using them?
How to update source definition?
Informatica settings are available in which file?
What are batches?
During the running session, output files are created by informatica server. Enlist few of them.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is INFORMATICA TESTING process
What does cheating measurement mean?
How would you join a node to the already existing domain?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Explain the mapping variable usage example in informatica
What is a mapplet/worklet in informatica?
What does refresh system mean, and what are its distinctive choice?