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

5 Answers
16604 Views
CTS, IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you define transformer?

914

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

922

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3268

hi friends pls forward impropmtu interview question

2097

Can you define cognos decision stream?

967

What are all the advantages of Cognos?

999

What do you mean by drill through report?

932

What is called a slice?

998

What are the roles defined by cognos platform?

1095

What is a Transformer?

1042

What is difference between informatica power mart and power center?

962

-------------How you design DWH?

2265

Mention the difference between ‘macros’ and ‘prompt’?

1093

write a query to display the departments with no employee?

1936

Define query studio?

968