SELECT * FROM TABLE_NAME WHERE ROWNUM=1 AND ROWNUM=3 AND ROENUM=5

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Question Posted / udaya

Answer Posted / udaya

SELECT * FROM TABLE_NAME WHERE ROWNUM=1 AND ROWNUM=3 AND
ROENUM=5

Is This Answer Correct ?

5 Yes

32 No

Please Help Members By Posting Answers For Below Questions

Can informatica load heterogeneous targets from heterogeneous sources?

1118

What is the fact table?

993

Define pmcmd command?

993

How can we use mapping variables in informatica? Where do we use them?

1099

Explain the use of aggregator cache file?

1188

Which means the first record should come as last record and last record should come as first record and load into the target file?

1021

How can you define user defied event?

976

Is it possible to define a single node as a Gateway node as well as worker node?

1058

Explain about Informatica server process that how it works relates to mapping variables?

1007

Where are the source flat files kept before running the session?

1011

What is Index Caches size?

1055

How to convert multiple rows to single row (multiple columns) in informatica

1317

Have you worked with/created Parameter file

1611

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

1097

What are the informatica performance improvement tips

1017