SQL · System and metadata

last_insert_rowid()

The rowid generated by the most recent insert. SQLite.

sqlRunnable example sql course

Syntax

last_insert_rowid()

Example

Open in the lab

CREATE TEMP TABLE notes (id INTEGER PRIMARY KEY, body TEXT);
INSERT INTO notes (body) VALUES ('a');
SELECT last_insert_rowid() AS id;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.