Thread: i want to get the third highest salary from a table?
View Single Post
  #14 (permalink)  
Old 04-30-2008, 12:51 PM
manjunath ps
 
Posts: n/a
Cool ANY answer. Re: i want to get the third highest salary from a table?
Quote:
Originally Posted by Prashant Yadav View Post
table is two fields
Emp_id and Emp_salary

How to get third highest salary without using YOP function.
[sql] select * from emp a where 2=(select count(*) from emp b where a.sal<b.sal);[/sql]
Reply With Quote