On 8/22/2011 3:43 PM, Black, Michael (IS) wrote: > I thought we were answering the question "how can I retrive the last row" -- > though we never got a definition of what "last" meant. I assumed "last > inserted".
Defining the meaning of the word "last" in terms of an expression that includes the word "last" is a bit circular. Let's say, "most recently inserted". > Sure you can construct an example that doesn't work. But he didn't ask how > NOT to do it. OK then, show how to do it. You haven't, yet. > Don't you agree that using autoincrement properly guarantees > retrieving the last inserted row? Or are you maintaining that is a false > statement? I maintain that the request you have shown - select id, data from Auto where id=(select max(id) from Auto); - doesn't always retrieve the most recently inserted row, and thus doesn't in fact solve the problem you claim it solves. > I'd like to see an example to disprove it if you maintain that its false. I have shown one. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
