write a query to display to 10 max record from the employee
table?
- 8 Answers
- 11596 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
Can you define query studio?
How security is concerned with Reportnet? Explain its implementing steps.
What do you understand by the term 'model durability'?
----------------------What are the User Securities?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is Metrics designer?
What is the model filter?
Can you define report item?
How Metrics Studio is better than Report Studio?
Explain difference between powerplay transformer and power play reports?
What is model?
Name the types of gateway?
Give me any example of semi and non additive measures?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
What are the types of studio present in Cognos?
