write the sql query to display 5th and 10th row in a table?
Answer Posted / harish
select * from emp where rownum<=&n;
if u give 5 insted of 'n' we get 5th record...
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What is the difference between drill through, drill across?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Can you explain the advantage of using shortcuts?
how u will design the report if the objects are available
What DB View and Bus View?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What do you mean by query studio?
-----------Diff b/w OLAP and RDBMS?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is cognos powerhouse?
------------ Diff b/w MemberCaption and MemberDescription?
How is cognos model organization works?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What you mean by drill across and what is the difference between drill through, drill across?