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
- 21010 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vsandhyana
select top 1 * from (select top 5 * from customers order by
salary desc) a order by salary asc
Thanks
Vikram Sandhyana
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / 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 |
Answer / pavan kumar
select * from emp e where 5=(select count(distinct sal)
from emp e where e.sal<=sal)
| Is This Answer Correct ? | 3 Yes | 8 No |
What is the use of Tree Prompt? Where it is used?Pls give me a real time example?
How is possible this scenario using in type-in prompt.?
set scope level in transformer
What is the difference between filter & Condition?
what is the difference between aggregation and role up aggregation ?
difference between join and union in reportstudio?
What is the deployment requirements used in cognos?
What is the difference between the standard and metrics folder?
what is prompt variable
1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?
what is the difference between list sequel and cross tab sequel?
Hi Friends,what are The Advantages In Cognos 10 Compared To Cognos 8.4?Enhancements in Cognos 10? Please Ans Me Pls
Teradata 
