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
- 21750 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravikumar2614
srikanth answer will work only if the table having only 4 records which r same.
if the table having 10 records, and 4 records r same out of 10 (1st, 5th, 6th, 8th records r same)
in above situation srikanth solution will not work
if wrong please correct me on ravi.info2614@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / divesh chasta
informatica solution :
first we will create seq and then filter out the third
record by this condition mod(id%3)=0
from this we can get third record.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
Based on the empid(assuming the persons are employees) us
can fire a quiry on that id.
| Is This Answer Correct ? | 0 Yes | 7 No |
Answer / pooja
hi all,
suppose 4 emp geting same sal as 4000... select * from emp
where sal=4000 and/having rowid=3
| Is This Answer Correct ? | 0 Yes | 14 No |
Answer / rag
We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,
like select col1,col2,rownum
from tab1
where rownum=3
| Is This Answer Correct ? | 1 Yes | 21 No |
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What are Business Components in Informatica?
in what type of scenario bulk loading and normal loading we use?
What is rank transformation in informatica
what is incremental aggregation ,with example?
What is sql query override? When did u use sql query override?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
How to delete duplicate record in Informatica?
What is the exact difference b/w IN and EXIST in Oracle..?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
Why filter transformation is an active one?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Teradata 
