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
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
whats the difference between previous version of cognos and cognos 8 BI?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
What are slice and dice?
What are the different uses of a repository manager?
------------------What is Inline Query?
What is Metrics designer?
How can we Maintain the Cube Security by Category level and Dimension level ?
Can you define report item?
Diff b/w Crossproduct and Outerjoin?
Can you define dimension?
What are shortcuts? Where it can be used? What are the advantages?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?