write a query to display to 10 max record from the employee
table?
Answer Posted / lakshmi reddy
top 10 records
select * from emp where rownum<=10
Based on maximum salary(hithest top 10 salaries with details)
select * from (select emp.* from emp order by sal desc)
where rownum<=10
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between static and dynamic conditions?
Give me any example of semi and non additive measures?
Explain difference between powerplay transformer and power play reports?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What are the different types of important services used in cognos?
What is meant by alternate drill down with ex?
Can you define report item?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Tell me about Dnamic and Static Dashboards?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What do you mean by drill across?
What is the deployment requirements used in cognos?