Select last identity for table in SQLite?

Question

I'm looking for the equivalent of Scope_identity() or @@identity in sql server, except for sqllite?

I'd hate to resort to a max select on the id column, but that is plausible.

Answer 1

Since I have never used SQL Server, I am not exactly sure what @@IDENTITY does, but if I understand this document correctly, then sqlite3_last_insert_rowid() may be what you are looking for.

Answer 2

last_insert_rowid()

This function returns the ROWID of the last row insert from the database connection which invoked the function. The last_insert_rowid() SQL function is a wrapper around the sqlite3_last_insert_rowid() C/C++ interface function.

Reference