I have this SQL query:
SELECT row1, row2, row3 FROM messages WHERE condition = '04301' AND row3 IN (SELECT MAX(row3) FROM messages WHERE condition = '04301' GROUP BY row1) GROUP BY row1
I want to use it in symfony, I have seen that it is used: $em->createQueryBuilder();
Something similar to this but with good parameters:
Can someone help me transform the SQL before to createQueryBuilder() of symfony?
Source: Symfony Questions