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
- 12150 Views
- iGate, I also Faced
- E-Mail Answers
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 issues you have faced in your project? How did you overcome those issues?
Is stop and abort are same in informatica?
How to generate sequence numbers without using the sequence generator transformation?
What is an unconnected transformation?
Explain the tuning lookup transformation - informatica
How do you load alternate records into different tables through mapping flow?
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 are the mapping parameters and mapping variables?
How many dimensions are there in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to create the source and target database connections in server manager?
Where do we use mapping variables in informatica?
Briefly define a session task?
Can we create two repositories on same database instance in oracle?
How to generate sequence numbers?
