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 difference between connected and disconnected architecture in ado.net?

1208

What is disconnected architecture in ado.net?

1044

What is data reader in ado.net?

1055

What is the role of data provider in ado.net?

1047

What is ado control?

1000

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1086

What are datareaders?

1027

What is ole db and odbc?

976

What are the key events of sqlconnection class?

1249

What are all the different methods under sqlcommand?

1031

What is sqldatasource?

980

Define atomicity?

1095

How can we check that some changes have been made to dataset since it was loaded?

1019

How many major types of connection objects in ADO.NET?

1088

What are the parameters that control most of connection pooling behaviours?

1120