how to fetch last inserted record?

Question

how can i fetch last inserted record for particular id?

for Example

PONumber	Qty
P00001	50
P00001	40
P00001	30
P00001	20
P00001	10

in this example i want to get my last inserted record ( PONumber - P00001 & Qty -10) by PONumber

Sanjeeb Lenka · Answer

SELECT TOP 1 PONumber FROM tablename ORDER BY PONumber DESC more details http://www.aspdotnet-suresh.com/2012/06/query-to-get-last-inserted-record-id-in.html

Iftikar Hussain · Answer

Hi If your table does not have identity column or primary column then you can try like this SELECT TOP 1 PONumber  Qty  row_number() over ( order by ( SELECT 2 ) ) AS ROWNUMBER FROM POInfo ORDER BY ROWNUMBER DESC Regards Iftikar

Kunal Vaishya · Answer

Hi  Using this you can get last Primary Key which inserted last SELECT @@IDENTITY AS 'Identity';

Jignesh Trivedi · Answer

hi you are performing bulk operation? if no so you cannot find last inserted record you must have filed like id or created date from that you can find last inserted value. Id filed may auto Identity... Select top 1 * from POTable where POnumber = 'P00001' order by Id desc Select top 1 * from POTable where POnumber = 'P00001' order by createdDate desc hope this will help you.