Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 8 Answers
- 12931 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / nasa
select *from emp where sal in(select max(sal) from emp where level<=10 connect by prior sal>sal group by level);
This query show the top 10 records based on the salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are shortcuts? Where it can be used? What are the advantages?
What do you understand by user class in cognos?
Can you explain model durability?
What is called Cognos powerplay?
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 is model?
How do we convert from Numeric to be Words?
-------------How you design DWH?
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 a cascading report and drillthru report? Why do we go for drill thru report?
How can I schedule reports in cognos?
whats the difference between previous version of cognos and cognos 8 BI?
What is a Framework manager?
Explain the difference between powerplay transformer and power play reports?
Why is auto-regression used in forecasting used on cognos platform?
