In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
- 6 Answers
- 8075 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is meant by query override?
list out all the transformations which use cache?
What are the different options available for update strategy?
What is a transaction control transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How you prepared reports for OLAP?
where to store informatica rejected data? How to extract the informatica rejected data?
how to load rows into fact table in data warehouse
wat are deployement groups in informatica, how it will be used for developers
What do mean by local and global repository?
What is the use of transformation?
Explain Dataware house architecture .how data flow from intial to end?
How can we create index after completion of load process?
What could be the possible resons of locks by user?
What are the various types of transformation?
