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 check if a datareader is closed or opened? IsClosed()

1025

How can we add relation between tables in a dataset?

996

What is the difference between the clone() and copy() methods of the dataset class?

1083

What is the provider being used to access oracle database?

993

Describe connection object in ado.net

1032

Which name space is used to get assembly details?

985

How to find the given query is optimised one or not?

971

Give few examples of datareader that is used in different dataproviders.

971

What is csdl entity framework?

1017

What is Dataset Object?

1007

Which is better entity framework or ado.net?

1043

Which ado.net object is very fast in getting data from the database?

1101

What is the purpose of using adodb?

955

What is the difference between a datareader and a dataset?

1029

Define connection string?

1066