In a table there are 1 million records there in which 3 records are duplicate

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?

Question Posted / luckylove1012

6 Answers
7645 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In a table there are 1 million records there in which 3 records are duplicate how will you find ou..

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

In a table there are 1 million records there in which 3 records are duplicate how will you find ou..

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

In a table there are 1 million records there in which 3 records are duplicate how will you find ou..

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

In a table there are 1 million records there in which 3 records are duplicate how will you find ou..

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

In a table there are 1 million records there in which 3 records are duplicate how will you find ou..

Answer / teja_dwh

use this query u will get this.For example i am taking emp
table

select * from emp where rowid not in(select max(rowid) from
emp group by empno)

Is This Answer Correct ?

0 Yes

1 No

In a table there are 1 million records there in which 3 records are duplicate how will you find ou..

Answer / haribabu

select ename,empno,count(*) from emp group by empno having count(*)>1;

Is This Answer Correct ?

1 Yes

3 No

Post New Answer