select top 1 * from <table_name> having salary < max(salary) order by salary desc