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
- 20998 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 do you mean by parallel execution of query?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
which table we load first in DW. dimension or fact? why?
4 Answers IBM, JPMorgan Chase,
Sales person are there in one company How to do Bursting on this particular requirement?
What is difference between content store and content manager?
Can you define bitmap index?
What is limited local? and the uses?
What is the use of powerhouse?
What is power prompts?Can somebody explain me.
What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?
What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.
How to create measures and Demensions?
Teradata 
