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
how you provide security to reports? How you provide security to packages ?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
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 is difference between data mart and data warehouse?
What is the difference between static and dynamic conditions?
What is a dimension?
Give the advantages of cognos?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What is the difference between regular dimension and derminant?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What r the names of the reports that you prepared?
Explain difference between powerplay transformer and power play reports?
What are the ways to import data into catalog?
What is the advantage of using shortcuts?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks