write the sql query to display 5th and 10th row in a table?
Answer Posted / kart
select * from (select rownum as rn,aone.* from aone)
where rn in(5,10);
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What is cognos reporting tool?
What is a Pivot?
what is online view?
how to create measures and dimensions?
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?
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..
Why cognos scenario is used?
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)?
Can you explain new content durability?
How to do Performence Tunning in Cognos Reports?
Can we test the report other than manual testing?
What do you mean by drill across?
What is main advantage datawarehousing over oracle?
What is the metric store database?