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 the User Securities?

1842

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

1029

What are various types of gateways in cognos?

1044

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

998

Can you explain dynamic query mode?

1051

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2306

--------------Diff b/w ODS and OLAP?

3196

Name the types of report?

946

how u will determine the performence tune will occur either in report or system

2130

------------------What is Inline Query?

2212

What is difference between informatica power mart and power center?

999

How to apply securities for reports in cognos connection?

2533

--------------Explain Table of contents?

2007

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1920

What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

2061