MYSQL - How to display nth highest record in a table for example ?

GeekInterview.com > Interview Questions > Database > MYSQL

Go To First | Previous Question | Next Question

MYSQL | Question 39 of 45

How to display nth highest record in a table for example ?

select salary from tablename order by desc limt 4;

Total Answers and Comments: 3

Last Update: June 17, 2008 Asked by: Vishwapati Mishra

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 17, 2007 01:10:39

prisharma

Member Since: December 2007 Contribution: 3

RE: How to display nth highest record in a table for example ?

Select sal From emp X Where 3 =

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

Is this answer useful? Yes | No

February 14, 2008 05:13:44

sampra

Member Since: February 2008 Contribution: 279

RE: How to display nth highest record in a table for example ?

select amt From Emp X Where 3 =

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

Is this answer useful? Yes | No

June 17, 2008 15:57:50

eswarqa

Member Since: April 2008 Contribution: 3

RE: How to display nth highest record in a table for example ?

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

Is this answer useful? Yes | No