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 is a repository? And how to add it in an informatica client?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is option by which we can run all the sessions in a batch simultaneously?
What is meant by pre and post session shell command?
Why filter transformation is an active one?
How union transformation is used?
What are the new features of informatica 9.x in developer level?
Enlist the advantages of informatica.
What are the differences between source qualifier and joiner transformation?
To import the flat file definition into the designer where should the flat file be placed?
How many ways are there to create ports?
what is song in infrmatica...?
What is the need of an ETL tool?
what is the Default Source Option For Update Strategy Transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.