Select * from (select rownum as rno, emp.* from emp) where rno 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 / amedela chandra sekhar

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

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the tuning techniques you applied during your last project

2012

Did u used latest transformations of 8.6.0? for what?

1868

What can we do to improve the performance of informatica aggregator transformation?

1075

How to delete duplicate row using informatica?

1018

What is workflow manager?

1027

How to go to the older version for a mapping?

1066

Explain how to import oracle sequence into informatica?

987

can u any challenge your project?

2014

What is pmcmd command?

1086

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2166

what is the difference between informatica6.1 and infomatica7.1

2251

In which transformation you cannot drag ports into it?

1296

What are the guidelines to be followed while using union transformation?

1118

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2044

Explian the Process of deployment groups in informatica

1040