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
How to load the data from a flat file into the target where the source flat file name changes daily?
Describe the impact of several join conditions and join order in a joiner transformation?
explan ur project architecture?
can anyone suggest best free Talend data integration training online
What is sequence generator transformation in informatica?
lookup transformation with screenshots
What is a code page?
What are the different ways to implement parallel processing in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the commit type if you have a transaction control transformation in the mapping?
What is the difference between stop and abort in informatica
Where can we find the throughput option in informatica?
Explain the difference between a data warehouse and a data mart?
Explain pushdown optimization $pushdownconfig parameter - informatica
Which is the t/r that builts only single cache memory?