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
- 13955 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / srinu
select * from(select rownum r,emp.*from emp order by sal
desc) where r<=10;
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
Can you define snapshot?
What are cognos connection initial page components?
Explain what is the difference between native sql and cognos sql?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is Metrics designer?
How to create model and how to test model?
------------- How to identify the Revenue Column in Report?
What are the different types of reports present in cognos?
What is defined as data mining?
What are all types of Batches?
What is the function of cognos dispatcher?
WHAT ARE THE DISTNICT VARIABLES?
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 ?
