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

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 / lokesh vepanjeri

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

I have a flat file, want to reverse the contents of the flat file

1105

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1970

What are active and passive transformations?

1069

How is union transformation utilized?

996

Please let me know how to make Data masking in informatica..

1696

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1058

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2300

Explain the tuning lookup transformation - informatica

977

Whats there in global repository

1673

Explain the difference between mapping parameter and mapping variable?

1020

Explain dynamic target flat file name generation in informatica

1033

Explain sessions?

1030

wat are deployement groups in informatica, how it will be used for developers

1700

Define Pmrep command?

1031

 Informatica Checkpoints

3307