select * from (select rownum rn,ename,job,sal 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 / uma

Answer Posted / uma

select * from (select rownum rn,ename,job,sal
from emp)
where mod(rn,2) <> 0;

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we create two repositories on same database instance in oracle?

1046

Separate from a database, an information bazaar, and an information stockroom?

1043

How to load last n records of file into target table - informatica

1037

explain about unit testing? in real time?

2160

where to store informatica rejected data? How to extract the informatica rejected data?

968

What is sq transformation?

1107

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

997

How do you load unique records into one target table and duplicate records into a different target table?

1180

State the differences between sql override and lookup override?

1144

Explain the shared cache and re-cache?

1073

What is a sequence generator transformation?

987

What are mapplets?

1228

What is Data Caches size?

1057

Which is the t/r that builts only single cache memory?

1152

Design a mapping to load a target table with the following values from the above source?

1309