how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / kondeti srinivas
select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp where rownum<=5)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
design of staging area?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can you use flat files in Mapplets.
Is stop and abort are same in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain incremental aggregation in informatica
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
difference between repository database and repository service?
Repository user profiles
What is a filter transformation?
Can anyone tell me the new features in Informatica 9 Version?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is a joiner transformation and why it is an active one?
What is a filter transformation and why it is an active one?