write the sql query to display 5th and 10th row in a table?
- 5 Answers
- 14918 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What is main advantage datawarehousing over oracle?
Why is auto-regression used in forecasting used on cognos platform?
What are cognos connection initial page components?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
How to select multiple values from type-in prompt?
What is zero-foot print?
1. Explain your project.
how you create security to reports?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What are all the types of hierarchies? What is the difference between set functions and filter
function in dimensional data? whats the difference between previous version of cognos and cognos 8 BI? What is a Cube?
