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
- 11935 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
Name the different lookup cache(s)?
What is expression transformation?
In informatics server which files are created during the session rums?
What are the components of Informatica? And what is the purpose of each?
How does a sorter cache works?
What is the use of transformation?
What is sorter transformation?
How do we call shell scripts from informatica?
What is aggregate cache in aggregator transformation?
Differences between connected and unconnected lookup?
update strategy transformation in informatica
What do you mean incremental aggregation?
what is SDLC way of code development?
server hot-ws270 is connect to Repository B. What does it mean?
what is the hint? how to use it to reduce the query processing in program?
