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

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to load the data from a flat file into the target where the source flat file name changes daily?

1026

What are the differences between oltp and olap?

939

What are the issues you have faced in your project? How did you overcome those issues?

2312

What is a code page?

1137

What is the use of source qualifier?

1091

How might you approve all mappings in the archive all the while?

977

What is xml source qualifier transformation in informatica?

1189

How would you copy the content of one repository to another repository?

974

Is there any way to read the ms excel datas directly into informatica?

995

What is mapping debugger?

966

During the running session, output files are created by informatica server. Enlist few of them.

950

What are the advantages of informatica?

970

What are the types of data warehouses?

1454

What is a connected transformation?

1072

How you know when to use a static cache and dynamic cache in lookup transformation?

1817