How to select the last inserted record from the identity column

In Microsoft SQL Server, the identity column provides you with an unique id for each record, which is auto-incremented.
To get the last added record from the database you will often want to select the latest added ID. Many have the false impression that they can select the biggest ID (number), and that will be the last added record. However, that’s not the case since the biggest ID is not always the latest. The solution is to use the following SQL query:


This will return the ID of the last added record in the MyTable table.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top