write the sql query to display 5th and 10th row in a table?
- 5 Answers
- 14961 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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
How to do Performence Tunning in Cognos Reports?
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?
Please explain the different stages in creating a report in cognos report net?
How to join multiple db in catalog?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What are the main services provided by application tier?
is cognos 7 is better than cognos 8
Why cognos decision stream is used?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
how u will determine the performence tune will occur either in report or system
What are all the types of hierarchies?
How do we convert from Numeric to be Words?
What are the components of the report studio?
Can you define slice?
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.
