How to fetch recently added record in sql

Question

How to fetch up the recently added record in sql? Thanks in Advance

Leon Puth · Answer

use a sql insert/update trigger to store details about ( or mark) the last added/updated record(s) or if you have an identity seed column (id) the largest number will represent the last added record but not the updated record. or add a datetimestamp column. or a flag column but this has gaps and is not advised.

Sandeep Mk Sharma · Answer

Thank you very much to all..

Anupam Singh · Answer

Hi Sandeep You can do this only and only if you have a datetime column or timstamp in your table. if you have one of them. you can use order by desc on these columns to get expected result.

Jignesh Trivedi · Answer

Hi I really not understand you question you want to fetch last added record in particular table or any tables? Please refer my article it explain about the physical row location using this feature you can find last updated row... http://www.c-sharpcorner.com/UploadFile/ff2f08/undocumented-physical-row-locator-function-in-sql-server-200/ hope this will help you.

Vithal Wadje · Answer

select top 1 *from TableName order by Id desc or select top 1 *from TableName order by CreatedDate desc