Informatica - Hi frnds, let me know the solution for this. i have emp table with eno, ename as columns with

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 134 of 313

Hi frnds,

let me know the solution for this. i have emp table with eno, ename as columns with duplicate rows.

Ex : eno ename
1 kiran
2 sena
3 naveen
1 kiran
4 dev
3 naveen
1 kiran
5 loki
3 naveen
1 kiran
6 shashi
1 kiran

etc...
so iwant to find out the third occurance of that duplicate row.i dont know where is that row . There r some millions of rows and so many duplicates for each row. plz suggest me if u know the answer. Thanks in advance.

Total Answers and Comments: 3

Last Update: February 14, 2007 Asked by: kiran kumar parsha

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 30, 2007 01:58:17

mithunmca

Member Since: January 2007 Contribution: 7

RE: Hi frnds, let me know the soluti...

hi i think that the following would give u an idea how to solve ur problem select distinct(ename) from emp_tab where empno in (select empno from(select empno,count(*) from emp_tab group by empno having count(*)>2));

Is this answer useful? Yes | No

February 07, 2007 09:15:42

chandra_rn

RE: Hi frnds, let me know the soluti...

i think this is query select * from emp where rowid > select max(rowid) from emp group by eno,ename

Is this answer useful? Yes | No

February 14, 2007 03:02:01

sai

RE: Hi frnds, let me know the soluti...

hi here is the answer

select * from t_name where rowid in (select rowid from t_name group by empno having count(*) =3);

Is this answer useful? Yes | No

Go To Top