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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What you mean by filtering of data?

533


how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....

3710


What is the use of connection object in ado.net?

561


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

536


Which database is the ado.net sql connection object designed for?

585






what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

532


What is csdl entity framework?

547


What is isolation?

562


Explain the difference between an ado.net dataset and an ado recordset?

530


How is it possible to get 2 tables of data at a time by using data reader?

492


How do you update a dataset in ado.net?

541


What is the difference between Data adaptor and Data set?

511


What is connection string?

522


If we are not returning any records from the database, which method is to be used?

737


Define atomicity?

573