How to take last inserted Record in SQL Server?

Take the below query to take last inserted Record.

select top 1 * from tablename order by fieldname desc