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

16 Answers
25872 Views
Cap Gemini, IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1955

Define pmcmd command?

1101

Differentiate between joiner and lookup transformation?

1156

How to update or delete the rows in a target, which do not have key fields?

1218

How to extract sap data using informatica? What is abap? What are idocs?

1248

How can we use batches?

1062

What is a grid in Informatica?

1112

What is the reusable transformation?

1097

list out all the transformations which use cache?

1238

When do you use sql override in a lookup transformation?

1137

What do think which one is the better joiner or look up?

1240

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1150

is it possible to index the data in cache of lkp transformation ?

2074

What is a node in Informatica?

1083

What is a stored procedure transformation?

1108