select * from (select rownum as rn,aone.* from aone) where rn in(5,10);

write the sql query to display 5th and 10th row in a table?

Question Posted / kart

Answer Posted / kart

select * from (select rownum as rn,aone.* from aone)
where rn in(5,10);

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What do you understand by ‘ibm predictive maintenance and quality’?

565

What do you mean by drill across?

575

What is called a slice?

577

Can you define snapshot?

553

what is degenerate key in oracle ?whare do we use it?

2061

------------- How to identify the Revenue Column in Report?

1820

How can we Maintain the Cube Security by Category level and Dimension level ?

1955

what is requery in cognos?

2068

What is cognos connection?

589

Define dimensions?

615

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2084

Please explain the different stages in creating a report in cognos report net?

564

hi friends pls forward impropmtu interview question

1687

Can you define cube?

586

What you mean by drill across?

616