We can use the query like SELECT TOP 1 ID FROM table ORDER BY ID DESC

How to fetch the last inserted record in a particular table?

Question Posted / skumar

Answer Posted / skumar

We can use the query like
SELECT TOP 1 ID FROM table ORDER BY ID DESC

Is This Answer Correct ?

11 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to connect and retrieve data from database using dataset

1060

What does adodb stand for?

1062

Is bulk insert faster than insert?

928

What are all the classes that are available in System.Data Namespace?

1021

Define isolation?

977

What is ado.net and its features?

990

How can we save all data from dataset?

1009

How to Read, Add, Update and Delete record in Entity Framework ?

1043

Which object of ado contains datarow datacolumn collection?

970

What is difference between ado.net and asp net?

1049

What is the difference between a datareader and a dataset?

1044

Explain executenonquery?

1146

Explain the difference in an abstract class and an interface?

930

Can datareader hold data from multiple tables?

1185

What is ole data type?

923