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

Can you define a catalog and types of catalogs in cognos?

656


What is Additive function?

1648


What is difference between content store and content manager?

622


-----------------What is Direct and Conventional loading?

1737


What is the difference between low affinity and high affinity connections?

638






Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

1883


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

1732


2. What functional area you worked on.

2001


What is difference between data mart and data warehouse?

621


what do u mean by bridge group? where we r using this one?

1623


What is model filter?

717


What are all the types of gateway used in Cognos?

628


----------------------What are the User Securities?

1541


hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2018


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4173