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

Answer Posted / lakshmi reddy

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

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

649


Write types of folders present in cognos?

658


plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2007


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

641


What is Bitmap Index?

697






What are the advantages of shortcuts?

618


I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1641


1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

1845


Can you define cognos decision stream?

669


How to publish a package by running Java Script?

1699


What are cognos connection initial page components?

718


What is difference between informatica power mart and power center?

647


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

745


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4010


HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1591