Article:
  SQL Subqueries
Subject:   i want a previous value of the max value
Date:   2005-10-27 23:35:55
From:   jagadishprem
Response to: i want a previous value of the max value

SELECT MAX(SAL) FROM EMP WHERE SAL<(SELECT MAX(SAL) FROM EMP)