How to get last record of database table in Laravel?

By Hardik Savani | July 14, 2016 | Category : Laravel

Sometimes we may require to get only last record of table in our project, we can get several way. We can fetch last record of database table using latest() or orderBy(). In bellow example you can see how i get then last record of table.

here is a simple example of get last record from tabel in laravel 6, laravel 7 and laravel 8 project.

I have "items" table and i want to get last record of "items" table. In first example i use latest() with first() because latest() will fetch only latest record according to created_at then first() will get only single record:

Using latest() belong to created_at field:

$last = DB::table('items')->latest()->first();

Now, In this example i used orderBy() that belong to id, it will always return max id record:

Using orderBy() belong to id field:

$last2 = DB::table('items')->orderBy('id', 'DESC')->first();

In this example latest() with argument, latest() will take created_at by default, if you want to give id then you can give argument as field name.

Using latest() belong to id field:

$last3 = DB::table('items')->latest('id')->first();

But If you want to get last inserted id then you have to follow this link :

How to get last inserted id in laravel 5?.

I hope it can help you...

Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
Follow Me: Github Twitter
***Do you want me hire for your Project Work? Then Contact US.

We are Recommending you: