use groupBy() then setMaxResults() #6938

New Issue

admin · 2026-01-22T15:41:47+01:00

admin commented

2026-01-22 15:41:47 +01:00

Originally created by @SakhriHoussem on GitHub (Mar 3, 2022).

I used Query builder to generate a subQuery with groupBy() and setMaxResults()


       $this->createQueryBuilder('r')
            ->select('AVG(r.score) as average')
            ->where('ps.id = :id')
            ->groupBy("r.type")
            ->setMaxResults(1)  // <=== not exist in sql query
            ->setParameter('id', $id)
            ->getQuery()
            ->getSql();

when i see generated SQL I found that limit 1 not exit

Originally created by @SakhriHoussem on GitHub (Mar 3, 2022). I used Query builder to generate a subQuery with `groupBy()` and `setMaxResults()` ```php $this->createQueryBuilder('r') ->select('AVG(r.score) as average') ->where('ps.id = :id') ->groupBy("r.type") ->setMaxResults(1) // <=== not exist in sql query ->setParameter('id', $id) ->getQuery() ->getSql(); ``` when i see generated SQL I found that `limit 1` not exit

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#6938