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

Informatica settings are available in which file?

938

What are mapplets?

1212

What does refresh system mean, and what are its distinctive choice?

1072

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2021

what is song in infrmatica...?

2162

Please let me know how to make encryption and decryption with example?

1847

What is DR strategy for Informatica project?

1114

What is a filter transformation?

987

Can you use flat files in Mapplets.

2610

Can we change Dynamic to Static or Persistent cache? If so what happens?

2147

Enlist the tasks for which source qualifier transformation is used.

981

What is dimensional table?

1002

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6910

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

982

what is $$$$?

2098