how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

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


Please Help Members By Posting Answers For Below Questions

How can you validate all mappings in the repository simultaneously?

758


what is size of u r database?

1850


Briefly define a session task?

592


What is resilience time?

655


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1536






Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

632


Define mapping and session?

585


What is meant by pre and post session shell command?

625


What do you understand by term role-playing dimension?

574


What are the advantages of informatica?

571


scenario where i can use only concurrent execution of workflow.

2544


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6084


What is the difference between informatics 7x and 8x and what is latest version?

547


what is SDLC way of code development?

1559


What is a mapplet/worklet in informatica?

689