title: unexpected token: LIMIT error in hql
body: <pre><code>        List&lt;AC_Customer&gt; lastAC_CustomersList = session.createQuery("from AC_Customer order by customer_pk DESC LIMIT 1").list()
  </code></pre>
  
  <p>when i execute this i got this error can any one please tell me what is wron with my hql query.</p>
  
  <blockquote>
    <p>org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: LIMIT near line 1, column 65 [from com.softlogic.models.AC_Customer order by customer_pk DESC LIMIT 1]</p>
  </blockquote>