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
- 21155 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srikanth
id sal
101 1000
102 1000
103 1000
104 1000
select id, sal from emp where rownum<=3
minus
select id, sal from emp wwhere rownum<=2;
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / hardeep
We can use Rank Trx, Select "salary" as Group by port and select "Date" or "Emp_id" as Rank Port and then Filter out records with Rank=3 thru Filter Trx.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / saumyabrata
1>Use a Sequence Generator Transformation,selet Start value
= 1 and Increment By = 1.
2>Use a Filter Transformation,take the ports Person and
Salary from source qualifier and the NEXTVAL port from
Sequence Generator Transformation into it.Set the filter
condition NEXTVAL = 3.
You are done.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / boss
How can you say which is thir record when all the salaries
are same...
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / gopi k
rownum is pseudo column, when query extracts rows rownum
will be appended to query. So where rownum = 3 condition is
a wrong one.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sanju
select * from (select salary.*,rownum r from salary where
sal=(select sal from salary group by sal having count(sal)
=4)) where r=3
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mr.lee
id sal
101 1000
102 1000
103 1000
104 1000
Select Rn, id, Sal, From (
Select Rownum Rn, id ,Sal From Emp)
Where Rn = 3
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vaas
Hi pooja,
would rowid be 3?
can u use having clause in ur query?
pl let me know poojaa
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
Answer / abhishek
U can achive this by using row_number function in source
qualifer example
select col1,col2,salary,emp_id from (select
col,col2,salary,emp_id , row_number() over (partition by
salary order by emp_id )as rec_seq from table)
Where
rec_seq=3
or by rank t/r in mapping
| Is This Answer Correct ? | 0 Yes | 0 No |
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
How you prepared reports for OLAP?
Mention few power centre client applications with their basic purpose?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
in what type of scenario bulk loading and normal loading we use?
What is powercenter on grid?
Did u used latest transformations of 8.6.0? for what?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
Explain what are the different versions of informatica?
How to recover sessions in concurrent batches?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
What is the target load order?
Teradata 
