Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17539 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rakesh
select rownum as rank,name,sal
from
( select name,sal from employees order by sal desc)
where
rownum=5
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What is the model filter?
What are the different uses of a repository manager?
-----------------What is Determination Model?
What is defined as catalog and types of catalogs in Cognos?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
Can you define a catalog and types of catalogs in cognos?
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 do you mean by Drill down and Drill Up?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What are all the advantages of Cognos?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
2. What functional area you worked on.
What is the difference b/w macros and prompt?
How to deploy from one server to another server?
How the Bursting happens in same report and how to Print the bursting Report?
