select * from emp where rownum<=&n; if u give 5 insted of 'n&#

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

Question Posted / harish

Answer Posted / harish

select * from emp where rownum<=&n;
if u give 5 insted of 'n' we get 5th record...

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are query items?

1027

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

2033

Can you define snapshot?

927

What are the batches and it’s details?

974

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2194

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

3305

What are all the components of Report Studio?

1102

What is defined as Query studio?

1107

tell me two or three issues from client side and how to solve those issues?

2168

Can you explain the advantage of using shortcuts?

1029

How can you link a query to a data container manually in Report Studio?

2360

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2766

how to connect datamarts

2799

what are the special features in cognos reportnet?

1061

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3568