How get the Id of inserted row in SQL [duplicate]

Question

My database table has ID column which is an auto incremental integer. While inserting data to the table its increment automatically I need to get the value of ID when a record is inserted.

Eg: table employee = |ID| NAME | ADDRESS|

the query is :

insert into employee(NAME, ADDRESS) values("azzi", "test adress")

there is a possible that we can change this query to return the ID soon after record inserted, some one help me to do that.

Answer 1

With the SQLite last_insert_rowid() function:

The last_insert_rowid() function returns the ROWID of the last row insert from the database connection which invoked the function.