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
- 22098 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 |
What is the Router transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is target update override
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
can you use flat file for repository?why?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
can we create index and drop index in exsisting table while using infomatica
select count(1) from emp? what is the o/p?
what is dimension table?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is primary and backup node?
can anyone explain me about retail domain project in informatica?
Teradata 
