Type: Posts; User: achinchawla; Keyword(s):
select top 1 * from <table_name> having salary < max(salary) order by salary desc