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 the difference between Dataset. clone and Dataset.copy?

988

Compare Data Reader & Dataset in ado.net?

940

What connected data?

888

What is disconnected data?

974

What is a serialized object?

939

What is the current version of entity framework?

898

What is Data Provider?

988

List the 4 common ado.net namespaces?

1078

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

921

Explain the difference between data reader and data adapter?

906

What are the differences between OLEDB and SQLClient Providers?

1066

Explain all the classes those are used for database connections between sql server and asp.net?

949

What is the difference between DataReader and DataSet in ADO.NET?

1073

What is ole access?

882

What are different layers of ADO.Net?

1036