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

Answer Posted / vimal katiyar

daer Archana your answer is nt complete so this s complete query fr last inserted record fetch from table

select * from <tablename> where id=(select max(id) from <table name>)

Is This Answer Correct ?    32 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is datasource in ado.net?

579


Explain advantages of ado.net?

553


What are the benefits of ADO.NET?

601


What is the full form of ado.net?

507


Explain the various objects in dataset.

522






What are the main differences between classic ado and ado.net?

512


What is ado and rdo?

495


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

552


How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

552


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

591


What is dataset and datatable in ado.net?

497


What is difference between connected and disconnected architecture in ado.net?

578


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

523


What are the major difference between classic ADO and ADO.NET?

511


What is ado object model?

509