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
What is an olap designer?
Can you define a query subject?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What is the difference between set functions and filter function in dimensional data?
What are shortcuts? Where it can be used? What are the advantages?
What are all types of Batches?
What is the use of cognos decision stream?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
------------- How to identify the Revenue Column in Report?
What is the deployment requirements used in cognos?
what is degenerate key in oracle ?whare do we use it?
What is difference between data mart and data warehouse?
What are the main services provided by application tier?