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

Answer Posted / sp hari

select * from emp where rowid=(select
decode(mod(rownum,2),0,null,rowid) from emp)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why sorter is an active transformation?

939


What is the use of target designer?

794


Explain sql transformation in script mode examples in informatica

788


Explain the difference between mapping parameter and mapping variable?

793


Make a note of the quantity vaults made in informatica?

755


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

959


How to partition the Session?

835


What are the mapping parameters and mapping variables?

806


What do you understand by SOA of Informatica?

751


Design a mapping to load the cumulative sum of salaries of employees into target table?

1169


Global and Local shortcuts. Advantages.

1661


 Informatica Checkpoints

3062


Explain the aggregator transformation?

841


Explain about Informatica server process that how it works relates to mapping variables?

816


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5174