How to get latest record based on one column in laravel?

Question

I want to select rows based on one column which is customer_id. Now the situation is there is a column ccustomer_id in Invoices table.

Here is how I am getting it now

Invoice::where('payment_status',1)->get()

But problem with this query is if there are two invoices for customer it will get both invoice. I need only latest one?

What will be query for that thing?

Answer 1

here is what you need to do

Invoice::where('payment_status',1)->order_by('created_at', 'desc')->first();