Programming solutions Sharing by Krunal Mehta: Second Highest Value SQL query

Tuesday, August 2, 2011

select max(FIELDNAME)
from TABLENAME
where FIELDNAME not in
(select max(FIELDNAME)
from TABLENAME);