Posted by: virusno1 January 6, 2009
SQL Guff
Login in to Rate this Post:     0       ?        
I just want to give answer to first question right now

select Top 1 T.Number from (select top 3 Number from NumberTable order by Number desc) T order by T.Number asc
Read Full Discussion Thread for this article