make use of MINUS operator
supposing to find second highest sal from tablename(table)
ie [sql]select max(sal) from( select sal from tablename
MINUS
select max(sal) from tablename)[/sql]