SQLite Forum

How to get the last row_id in a table without inserting anything
Login
Note that:

```
select max(whapydoodle) from dingdong;
```

is equivalent to:

```
select max(rowid) from dingdong;
```

because there is no column named "rowid" so references to it refer to the rowid of the table, which happens to have the explicit name "whapydoodle".