select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp w

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

Question Posted / kondeti srinivas

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

Please Help Members By Posting Answers For Below Questions

difference between informatica 8.1.1 and 8.6

3659

Which transformation is needed while using the Cobol sources as source definitions?

1154

In development project what is the process to follow for an etl developer from day1

1696

What is mapping debugger?

987

What does reusable transformation mean?

1116

What is repository manager?

968

What are the different transaction levels available in transaction control transformation?

1169

What are the new features of Power Center 5.0?

1752

scenario where i can use only concurrent execution of workflow.

3138

What is the use of target designer?

1021

How to create a non-reusable instance of reusable transformations?

1096

What is Index Caches size?

1092

Explain pmcmd command usage in informatica

1105

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2038

Differentiate between router and filter transformation?

1000