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

What is ole2 format?

898

What is the current version of entity framework?

954

How can we serialize the dataset object?

992

Which is better ole db or odbc?

898

Do you use stored procedure in ado.net?

1020

What is namespace in ado.net?

1007

How do you connect to sql server database without using sqlclient?

1097

What are the differences between OLEDB and SQLClient Providers?

1142

What is ado.net tutorial?

917

Which object holds only data and does not interact with data source?

973

What is ole access?

938

Explain the difference between ado and ado.net?

935

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

4442

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1095

Explain the different row versions available in table?

1049