select last row of table

How to select last row of开发者_如何学C table in SQL SERVER 2005

In general like this

select top 1 *
from table 
order by SomeColumn desc