Get all duplicate records in table

SELECT *

FROM table t1

WHERE t1.domain_id = 1569

AND t1.is_active = 1

AND (t1.field IN (SELECT t2.field

                 FROM table t2

                 WHERE t2.is_active = 1

                 GROUP BY t2.field

                 HAVING COUNT(t2.field) > 1))

SELECT l0_.*

FROM table l0_

inner join table n2 on n2.field = l0_.field

where l0_.id <> n2.id

AND l0_.is_active = 1

Group By l0_.id

$queryBuilder

    ->innerJoin(Table::class,'table', Query\Expr\Join::WITH, 'entity.field = table.field')

    ->andWhere('entity.id <> table.id')

    ->andWhere('table.isActive = 1')

    ->groupBy('entity.id')

;