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
- 12341 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
What are the types of data warehouses?
Name the different lookup cache(s)?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How can informatica be used for an organization?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is primary and backup node?
What is a filter transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
When do you use sql override in a lookup transformation?
Define pmcmd command?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the way to execute pl/sql script using informatica mapping?
What is an aggregator transformation?
