Interested to Buy Any Domain ? << Click Here >> for more details...
Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 20873 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / prashant
SELECT min(salary)
from emp
where salary in (select distinct top 5 salary from emp
order by salary desc)
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is Additive function?
Can you define snapshot?
What is the difference between group and associare?
9. What was the most complex type of report you dealt with?
-------------How you design DWH?
which type of project we r going to snowflake schema
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What is the model filter?
What do you understand by the term 'model durability'?
What are the considerations regarding performance kept in mind while setting up cognos?
What are the steps to import the two data sources in framework manager?
Define query items?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What you mean by drill across and what is the difference between drill through, drill across?
Why are meta service important then other services?
