Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21534 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishnakanth.ch
It can be retrieved with a simple subquery.
For example, I create a table sal with id,sal
id sal
-------
11 1000
22 1000
33 1000
44 1000
to retrieve the third column with the same salary
use the below query:
select id,sal from (select id,sal,rownum r from sal)
where r=3;
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a mapplet/worklet in informatica?
How you prepared reports for OLAP?
What is a joiner transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Briefly define reusable transformation?
whats the logic to load the lower level of granularity of data to fact table.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain the features of connected and unconnected lookup.
What is InformaticaPowerCenter?
How are the sources and targets definitions imported in informatica designer?
How is union transformation utilized?
What do you understand by a term domain?
What is the difference between source qualifier transformations source filter to filter transformation?
