Monday, May 10, 2010

Need to find second highest salary from table

Ok..i know there are various methods to do this...but was looking for optimized query to find the second highest salary from say..employee table that has id, Name and Salary as fields! Can i do it in one query?? Help!!!