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

Answer / lokesh vepanjeri

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

Answer / santosh kumar sarangi

select * from emp where empno in (select empno from emp
group by sal having count(*)>1)

Answer / vivek singh

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

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)

Answer / haribabu

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

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

What all join we can perform in LOOKUP transformation?

0 Answers  

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

How do you recover rows from a failed session

1 Answers  

What is a design?

1 Answers  

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

how to use incremental load?

2 Answers   TCS,

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

What is transformation?

0 Answers