How to get last/Bottom row of the table in Sqlite via Sql Query

Question

I am trying to fetch the last row of my sqlite3 db. can anybody tell me the query syntax.

Accepted Answer

```
SELECT field
FROM TABLE
ORDER BY field DESC
LIMIT 1
```

assuming that ordering by `DESC` puts your last row first

Solution