Thread
:
How to find second highest value of a column in a table?
View Single Post
#
12
(
permalink
)
10-12-2007, 10:03 AM
Sameer
Posts: n/a
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
Sameer