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
What does executereader return?
Explain ODP.net
Describe the disconnected architecture of ADO.NET’s data access model.
Explain what is datagrid with an example?
How to check if a datareader is closed or opened? IsClosed()
What is the difference between executenonquery () and executescalar ()?
differance between ADO vs ADO.Net?
Which parameter of ConnectionString is used to specify the name of the database?
Explain the difference between ado and ado.net?
What is dataadapter in ado.net?
How can I retrieve two tables of data at a time by using data reader?
What is meant by executenonquery?
What is the difference between Data adaptor and Data set?
Does entity framework use ado.net?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)