How can I query Eloquent data from a database with only the latest data?

Question

Laravel

Hello!

How can I query Eloquent data from a database with only the latest data?
It is necessary to weed out from the request data that is duplicated but older by date.

For example, we have the following data:
id name marker num created_at
1 Test1 root 100 2021-03-18
2 Test2 user 100 2021-03-18
3 Test2 user 120 2021-03-21
4 Test3 guest 100 2021-03-22

And you need to get:
id name marker num created_at
1 Test1 root 100 2021-03-18
3 Test2 user 120 2021-03-21
4 Test3 guest 100 2021-03-22

Answer 1

Specifically, your request "preferably beautiful without DB" cannot be done.

\DB::query()
    ->from((new Name())->getTable(), 't')
    ->where('created_at', '=', function ($q) {
        $q
            ->from((new Name())->getTable(), 't2')
            ->selectRaw('MAX(t2.created_at)')
            ->whereRaw('t2.name = t.name')
            ->whereRaw('t2.marker = t.marker');
    })
    ->get();