View Single Post
  #12 (permalink)  
Old 10-12-2007, 10:03 AM
Sameer
 
Posts: n/a
Default ANY answer. Re: How to find second highest value of a column in a table?

[sql]select * from tablename orderby salary limit 1 offset 2[/sql]

use 3 for third highest 4 for 4th highest after offset

sameerargade@gmail.com
Reply With Quote