write the sql query to display 5th and 10th row in a table?
Answer Posted / gautam ramteke
select *
from(select rt.*,rownum r from (select * from gpr_employee
order by hire_date)rt)
where r in (5,8);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What junk dimension contains?
What are the roles defined by cognos platform?
Why are meta service important then other services?
What you mean by drill across and what is the difference between drill through, drill across?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Can you define drill down and drill up?
-----------With out using DrillThrough how to do Reports?
in u r data u having duplicates how to fetch the latest data in our report?
Explain the different types of views used in cognos.
What are the different uses of a repository manager?
What is meant by junk dimension?
what are the filters in framework manager and report studio?
what are the special features in cognos reportnet?
What is the difference between regular dimension and derminant?
What is the enterprise class platform architecture of cognos 8?