Thread
:
i want to get the third highest salary from a table?
View Single Post
#
13
(
permalink
)
04-24-2008, 12:20 PM
vens
Posts: n/a
ANY
answer.
Re: i want to get the third highest salary from a table?
[sql]select sal from employees .e where &n=(select distinct(sal) from employees where e.sal<=employees.sal);[/sql]
vens