SQLite: What is the ID of the last inserted row?

Question: We have added a new row into a SQLite database using an INSERT statement. Now we need the ID of the last inserted row to use it in another statement or to store it somewhere else.

Solution: SQLite is providing the function last_insert_rowid() returning the ID of the last inserted row. Here is an example:

SELECT last_insert_rowid() FROM tab

Suppose our table is named "tab" and we have just added a new entry into this table. In this case, the request from above provides us the ID of this last entry.