If a table have identity column then u can fetch the last inserted record

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

Question Posted / archana

Answer Posted / archana

If a table have identity column then u can fetch the last
inserted record through following query:

"select max(ID) from test"

Is This Answer Correct ?

2 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Does ado.net use odbc?

904

Command objects uses, purposes and their methods.

937

What is dataadapter in ado.net?

884

How is entity framework different from ado.net?

910

How do I delete a row from a DataTable?

1088

Where is adodb dll located?

926

What are the types of databinding?

940

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

1000

Which method is used by command class to execute SQL statements that return single value?

993

What is ole in excel?

903

What are the namespaces used in ADO.Net to connect to a database?

1125

How can we add/remove row's in "datatable" object of "dataset"?

974

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

979

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

932

What is the use of data grid?

912