Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 7 Answers
- 14052 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / m m naidu
To display first 10 records we can write the query as
select * from(select * from emp order by ename desc) where
ronum<=10;
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
can you tell me what are the dimension tables are used in project
What is an olap designer?
What is a Datastore in 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 ?
Define report item?
What is difference between primary key and unique key constraints?
What do you understand by the cognos?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What is called materialized view?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
what are the errors faced while bursting the reports and how to solve those errors?
What is difference between informatica power mart and power center?
What are the steps to import the two data sources in framework manager?
Name the types of report?
