title: Set LIMIT with doctrine 2?
body: <p>I trying to write a query (with subquery) but i don't know how set a limit in my subquery.
  My query:</p>
  
  <pre><code>$query_ids = $this-&gt;getEntityManager()
        -&gt;createQuery(
          "SELECT e_.id
          FROM MuzichCoreBundle:Element e_
          WHERE [...]
          GROUP BY e_.id")
       -&gt;setMaxResults(5)
      ;
  
  $query_select = "SELECT e
        FROM MuzichCoreBundle:Element e 
        WHERE e.id IN (".$query_ids-&gt;getDql().")
        ORDER BY e.created DESC, e.name DESC"
      ;
  
  $query = $this-&gt;getEntityManager()
        -&gt;createQuery($query_select)
        -&gt;setParameters($params)
      ;
  </code></pre>
  
  <p>But <strong>->setMaxResults(5)</strong> doesn't work. No 'LIMIT' in the SQL query. Can we do simple LIMIT with doctrine 2 ?</p>