select top 1 * from ( select top 3 val from #t order by val ) s order by s.val desc
select top 1 * from ( select val from #t order by val ) s order by s.val desc