write a query to display to 10 max record from the employee
table?
- 8 Answers
- 10627 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 the themes in a data warehouse?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
what is the difference between filter and condition?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
What is a Pivot?
Explain the different types of views used in cognos.
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
How the Bursting happens in same report and how to Print the bursting Report?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
What is set to be cardinality?
What is catalog and types of catalogs in cagonos and which is better?
Name the types of report?
