Select * from (select rownum as rn, emp.* from emp) where rn in (1,3,5);

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 (select rownum as rn, emp.* from emp) where
rn in (1,3,5);

Is This Answer Correct ?

22 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1033

What are multi-group transformations?

1072

What are roles and groups and benefits of using them?

1044

What is the way to execute pl/sql script using informatica mapping?

1583

What is intricate mapping?

1174

What are the different components of powercenter?

1032

What are the differences between joiner transformation and source qualifier transformation?

1148

Clarify the aggregator change?

1013

What is the Process to creating lookup transformation in informatica

1032

How do you remove duplicate records in informatica? And how many ways are there to do it?

1154

Slowly changing dimensions, types and where will you use them

1690

Explain lookup transformation in informatica

1049

What do you mean by worklet?

1051

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

985

Target increases every day even though no new record was inserted

1562