how to use **distinct on()** in laravel's query builder if using Postgre? [closed]

Question

i want the syntax for distinct on() in laravel query builder.

Answer 1

Eloquent does not have a distinctOn function.

You could use a raw query

$query->select(
    \DB::raw("DISTINCT ON (field1, field2) *")
);

or install a package that adds the distinctOn method, such as this one.

If you're using Laravel 9 or above - native distinct on support is available, as long as you're using the Postgres driver.

$query->distinct(['field1', 'field2']);