View Single Post
  #13 (permalink)  
Old 04-24-2008, 12:20 PM
vens
 
Posts: n/a
Cool 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]
Reply With Quote