Second highest value could be find out by entering this command:-
Let say u want to find out salary(second highest) from employ table then..

[sql]SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT MAX(SALARY) FROM EMPLOYEE)[/sql]


Regards,
Mohammed Obaid Khan
Pune, Maharashtra
India