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
- 21137 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
What is the difference between router and filter?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is workflow? What are the components of the workflow manager?
What are the issues you have faced in your project? How did you overcome those issues?
can anyone suggest best free Talend data integration training online
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Design a mapping to load the cumulative sum of salaries of employees into target table?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Where do we use mapping variables in informatica?
How to update or delete the rows in a target, which do not have key fields?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is a mapplet/worklet in informatica?
What is an aggregator transformation?
