Interested to Buy Any Domain ? << Click Here >> for more details...
In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
- 6 Answers
- 9273 Views
- I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
write a query eg:take emp table and empno,sal,deptno columns
have assume the duplicates.
select * from emp x where rowid>(select min(rowid) from emp
where empno=x.empno
and sal=x.sal
and deptno=x.deptno);
you will only duplicate records in the emp table.
chandumba2005@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
expain about the tune parameters?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the performance considerations when working with aggregator transformation?
server hot-ws270 is connect to Repository B. What does it mean?
What are batches?
What do you understand by a term domain?
What is the procedure for creating independent data marts from informatica 7.1?
What are mapplets?
What is the difference between router and filter?
What are the static cache and dynamic cache in informatica?
What is a mapplet/worklet in informatica?
what is the complex transformation you used in informatica
Explain scd type 3 through mapping.
What is a passive transformation?
