How to select the last inserted record from the identity column

SELECT @@IDENTITY FROM MyTable;