In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / lokesh vepanjeri
select * from emp where rowid not in (select max(rowid)
from emp group by empno);
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / santosh kumar sarangi
select * from emp where empno in (select empno from emp
group by sal having count(*)>1)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vivek singh
select * from emp1
where rowid not in (select max(rowid) from emp1 group by empno);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / haribabu
select ename,empno,count(*) from emp group by empno having count(*)>1;
Is This Answer Correct ? | 1 Yes | 3 No |
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
what is confirmed dimension?
tell me the rules and responsblites in our project(my project is development)
Explain lookup transformation in informatica
Whatis the difference between View and Materialized View ?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
What is workflow monitor?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
what is runtime variable?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
How to create the source and target database connections in server manager?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?