prisharma

 Profile Answers by prisharma 

• Dec 17th, 2007

 

Select sal From emp X Where 3 =

( Select Count(Distinct sal) From emp Where sal >=X.sal )

 

sampra

 Profile Answers by sampra 

• Feb 14th, 2008

 

select amt From Emp X Where 3 =

( select count(distinct sal) From emp where sal >=X.sal )

eswarqa

 Profile Answers by eswarqa Questions by eswarqa

• Jun 17th, 2008

 

select sal from emp order by sal desc limit 3, 1;

This will select the 4th highest salary from emp table, i.e picks up after the third, next value

sachin0631

 Profile Answers by sachin0631 

• May 21st, 2009

 

select distinct a.sal from emp a where
n=(select count(distinct b.sal)
from emp b where a.sal<=b.sal)

here just input the value of 'n' in above query..
like

n=2 to find second highest sal
n=3 to find 3rd highest sal and so on...

cheers...

kumarkiranm

 Profile Answers by kumarkiranm 

• May 31st, 2010

 

Following query will fetch the record of emp, who is having nth highest sal: 

SELECT * FROM `emp` where sal = (select distinct sal from emp order by sal desc limit n-1,1)

For 1st highest : LIMIT 0,1

For 2nd highest: LIMIT 1,1

so on..

gakorde

 Profile Answers by gakorde 

• Jun 13th, 2010

 

SELECT SAL FROM (SELECT SAL FROM EMP ORDER BY SAL DESC LIMIT n) as TEMP ORDER BY SAL ASC LIMIT 1

sadaqat

 Profile Answers by sadaqat 

• Aug 18th, 2010

 

If your table name is emp and the name, sal are two columns of table. then you can easily find out nth highest salary from the table with the help of this query

SELECT DISTINCT sal FROM emp ORDER BY sal DESC LIMIT (n-1),1 ;

If you want to find 3rd highest sal your query will be

SELECT DISTINCT sal FROM emp ORDER BY sal DESC LIMIT 2,1 ;

Siva Krishna Yarlagadda

 Profile Answers by Siva Krishna Yarlagadda 

• Apr 3rd, 2011

 

select salary form employee order by salary desc limit 1,1

3rd Highest Salary-->Change Limit 2,1
4th highest salary-->change Limit 3,1

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

Suppose we have to find records in the emp_salary table with nth highest value for salary.

select * from emp_salary whare salary in(select distinct salary from emp_salary order by salary desc limit n-1,1);