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
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What is defined as catalog and types of catalogs in Cognos?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What are all the advantages of Cognos?
Explain the difference between powerplay transformer and power play reports?
what are slowly changing dimensions? Why we are used scd?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
5. Which type of report you build more, list, crosstab or chart and why?
What is the function of model design accelerator?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
------------------What is Inline Query?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
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........
Can you define cognos impromptu?