last

The last method returns the last record found in the given table.

const user = await User.last()
// User{id=9000}

select "users".* from "users"
order by "users"."id" desc nulls last
limit 1

Chaining

Similar to other execution methods, last can be chained with other chainable query methods, such as order.

await User.order({ email: 'asc' }).last()

select "users".* from "users"
order by "users"."email" desc nulls last
limit 1

tip

In some cases, lastOrFail may be more ideal, since it will raise a RecordNotFound exception, causing the request to fail with a 404 error automatically.