Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 does executereader return?

919


Explain ODP.net

951


Describe the disconnected architecture of ADO.NET’s data access model.

1020


Explain what is datagrid with an example?

1053


How to check if a datareader is closed or opened? IsClosed()

989


What is the difference between executenonquery () and executescalar ()?

903


differance between ADO vs ADO.Net?

1014


Which parameter of ConnectionString is used to specify the name of the database?

1012


Explain the difference between ado and ado.net?

895


What is dataadapter in ado.net?

895


How can I retrieve two tables of data at a time by using data reader?

963


What is meant by executenonquery?

904


What is the difference between Data adaptor and Data set?

993


Does entity framework use ado.net?

947


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?)

966