Hello guys..

I have a problem. I need to access the latest row in an sql database table. I didnt find anyway for that..So please any one help me!!!!!

Pramod

What do you mean by "latest row"?

Concepts like "latest", "earliest", "first", "next", etc. only have meaning when you are dealing with an ordered set of data. Since rows in a table in a relational database are inherently unordered, none of these concepts have any meaning.

Is there a column in your table which allows you to order the row data? For example, if you have a datetime column such as 'DateEntered', then you could easily find the row with the maximum value, and that would correspond to the 'latest' row.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

http://p2p.wrox.com/topic.asp?TOPIC_ID=40967

May be what you are looking for. This explains how to get the most recently inserted record. It does assume you have an auto incrimenting integer as a promary key field in your table, do you? If not, why not. IMO even if you dont need it, throw it in there - there is a good chance you may need it in the future.

Others:
There is an un-answered question in this post, I am most interested to hear opinions on it

Wind is your friend
Matt