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!!!