Get latest values in GROUP BY using Laravel Eloquent ORM

Question

I'm trying to understand how Laravel's Eloquent ORM works and was looking at the following MySQL query:

SELECT id, name, date FROM tablename GROUP BY name ORDER BY date

The use of GROUP BY always returns the oldest values of name. Is there a way to return the latest value instead?

Answer 1

Try following code,

Tablename::select('id', 'name', DB::raw('max(date) as latest_date'))
 ->groupBy('name')
 ->orderBy('latest_date')
 ->get()