how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 22019 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / priyank
select * from (select rownum rn,emp.* from emp) where mod
(rn,2)=1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the types of schemas we have in data warehouse.
4 yrs etl devloper roles and responsibilities?any body give solutions
can we override a native sql query within informatica? Where do we do it?
How many ways a relational source definition can be updated and what are they?
Differences between connected and unconnected lookup?
How to load the data from people soft hrm to people soft erm using informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What do you understand by term role-playing dimension?
What is the surrogate key?
What is a code page?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
what is the hint? how to use it to reduce the query processing in program?
What does role playing dimension mean?
Differentiate between sessions and batches?
