select last row of table

Question

How to select last row of table in SQL SERVER 2005

Answer 1

In general like this

select top 1 *
from table 
order by SomeColumn desc