Shree

• Mar 26th, 2006

 

This should work:select max(emp_salary) from emp e1 where (select count(emp_salary) from emp e2 where e2.emp_salary>=e1.emp_salary)=5However if you want to display the corresponding employee info like first name or so,....I suggest using top keyword, as follows:select top 1 emp_name, emp_salary from emp where emp_name != (select top 1 emp_name from emp order by emp_salary desc) order by emp_salary desc

IrfanAbdulRehman

 Profile Answers by IrfanAbdulRehman 

• Mar 31st, 2006

 

select sal, deptno, ename, rk from
(select sal,deptno, ename,rank() over(order by sal) rk from emp)
where rk =5

nileshsingh

 Profile Answers by nileshsingh 

• May 19th, 2006

 

select level,max(sal)

from <table_name>

where level = 5

connect by prior sal > sal

group by level

Sivakumar

• Sep 7th, 2006

 

Hi,

 This will solve your problem.

Use "select salary from emp a where 5 = (select count(distinct(salary)) from emp b where b.salary>= a.salary) "

Thanks & Regards,

Sivakumar

Rajeev

• Feb 2nd, 2007

 

Select Max(Salary) from table_Name Where Salary Not IN (Select TOP 5 From Table_Name order by salary desc)

mukesh kumar tiwari

• Apr 9th, 2007

 

select salary from tablename group by salary dsc limit 4,1;

Imran_Javed

 Profile Answers by Imran_Javed 

• May 9th, 2008

 

SELECT *
FROM  (SELECT  ename ,sal,
                  dense_rank() over (ORDER BY sal DESC) max_sal
        FROM emp)
WHERE max_sal= 5;

monika1985

 Profile Answers by monika1985 

• May 28th, 2008

 

select sal from emp e
where 4=(select count(distinct(sal) from emp where sal>e.sal)