get last record by date

hi! how do I get the last record by date? this return the first record by date

$station = Station::groupBy('date')->orderBy('date', 'DESC')->get();

webrobert

3 years ago

Best Answer

Level 51

https://laravel.com/docs/9.x/queries#ordering

https://laravel.com/docs/9.x/queries#latest-oldest

1 like

Rumnaz khan

3 years ago

Level 3

Try this:

$station = Station::whereIn('id', function($query) {
                       $query->from('station')->groupBy('date')->selectRaw('MAX(id)');
                    })->get();

Please or to participate in this conversation.