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 anyone tell me the new features in Informatica 9 Version?

2132

How can we handle two sessions in informatica?

1034

What are the different types of transformation available in informatica.

1105

what are factless facts? And in which scenario will you use such kinds of fact tables.

1811

Explain sql transformation in script mode examples in informatica

1139

How to handle decimal places while importing a flatfile into informatica?

1192

What is a difference between complete, stop and abort?

1086

How to join three sources using joiner?

1119

How do you manage the Parameter files while migrating your data from one environment to another environment?

1029

What is a shortcut and copy in Informatica and how two are different with each other?

1199

What do you mean by channel change?

1051

Explain the use of aggregator cache file?

1258

without table how to come first record only in oracle?

2257

What is pmcmd command?

1126

what is the -ve test case in your project.

2408