title: HQL limit in subselect query
body: <p>I want to insert foreign key of one table in another on basis of certain criteria. Structure is like </p>
  
  <pre><code>insert into CustomerResult(customer,draw) select c.idCustomer, from Customer c,Draw d where ..... and  c.idCustomer in (select cc.idCustomer from Customer cc where ..... limit 10)
  </code></pre>
  
  <p>here i want to insert only fix no of records which fulfill certain criteria. I know hql has no limit keyword but  want to implement like this. any suggestion? </p>