write a query for how to eliminate the duplicate rows
without using distinct?
Answer Posted / murali udayagiri
Assume some duplicate data is there in emp table. Try the
below to eliminate duplicate.
select * from emp
union
select * from emp;
Thanks,
Murali Udayagiri
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What are the advantages of using informatica as an etl tool over teradata?
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?
Clarify the aggregator change?
What is a node in Informatica?
Differences between connected and unconnected lookup?
Enterprise data warehouse your projects phase by phase explain?
Can we override a native sql query within informatica?
How identifying bottlenecks in various components of informatica and resolving them?
What is aggregate cache in aggregator transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Can we create a node as a gateway node and the same node can be assigned to a grid?
How many ways are there to create ports?
What is event and what are the tasks related to it?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How can informatica be used for an organization?