select * from(select emp.*,rownum r from emp) where r=5 or r=10

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

Question Posted / lakshmi reddy

Answer Posted / lakshmi reddy

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you improve the performance of the Cognos Analytics report

993

What is the size of database for you project?

1565

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

2265

What do you mean by query studio?

906

What is model?

935

how you migrate reports to cognos 8 from previous versions?

1007

How to publish a package by running Java Script?

2047

When we save a report in report studio with what extn it save?

1020

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1807

What is a Pivot?

1077

What is the difference between ‘macro’ and ‘prompt?

1026

What is main advantage datawarehousing over oracle?

970

What are the types of studio?

1115

how can you get the errors in job? when loops are araised we get error?

2079

What do you understand by the cognos?

926