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.

Answer 1

SELECT field
FROM TABLE
ORDER BY field DESC
LIMIT 1

assuming that ordering by DESC puts your last row first