Thread: Need help with max
View Single Post
  #2 (permalink)  
Old 03-15-2008
mira mira is offline
Jr. Member

Join Date: Mar 2008
Posts: 263
BRL$: -164.73
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 41
mira is on a distinguished road
Default Re: Need help with max
You can use Limit to get your problem solved. Use it following way.

select salary from <Table> order by desc Limit 5,1

Try it and let me know if you have any problem with it.

To receive latest updates about BRL Forums, Subscribe to Latest Updates Thread.
Reply With Quote