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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of cognos?

566


------------ Diff b/w MemberCaption and MemberDescription?

1905


What is a Folder?

677


Why cognos decision stream is used?

632


What is the difference between a data mart and a data warehouse?

541






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

1556


What is cognos powerhouse?

584


What are the advantages of using cognos sql?

657


What is the model filter?

596


what are the dimensions that you have in your current project?list them?

1633


i have one file i saved in csv how can i take these file into framework manager

1535


What is catalog and types of catalogs in cagonos and which is better?

514


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1516


2. What functional area you worked on.

1911


What is the difference b/w macros and prompt?

592