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

What is Serialization in .NET? what are the types of Serialization?

1041

Which object holds only data and does not interact with data source?

932

What is ole in excel?

908

What do you mean by ‘batch updates’?

1001

What is ado in agriculture?

905

Which name space is used to get assembly details?

946

Is bulk insert faster than insert?

879

Define ado.net?

1060

What is ado data control?

965

What are the several execute methods of ado.net?

887

What is ole db and odbc?

879

What is full form of ado?

1007

What are the key events of sqlconnection class?

1144

What is the difference between ado.net and oledb?

921

What is difference in record set and dataset?

1012