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
- 11941 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
Can we get 1st record through Informatica(without sequence number).
Why update strategy and union transformations are active? Explain with examples.
How do you migrate data from one environment to another?
Can u generate reports in Informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is incremental aggregation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How do you use reject loader.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Can we override a native sql query within informatica?
What is standalone command task?
How to convert multiple rows to single row (multiple columns) in informatica
what is SDLC way of code development?
Explain the different lookup methods used in informatica?
