SQLite Forum

How to get the last row_id in a table without inserting anything
Login
Chronological Hierarchical 
Hi,I tried " select max(id) from table;"
Table has 47 rows but the query give me an int of 1.
this is my query.

  query= "select MAX(id) from table1";
  rc = sqlite3_exec(db,query.c_str(),NULL,0,NULL);

Do I miss something ?
thanks