This content has been marked as final.
Show 2 replies
-
1. Re: how to do this kind of jboss-ql?(select top n from....)
aloubyansky Apr 3, 2004 5:33 AM (in response to fingertiploneliness)Like this
<jboss-ql>SELECT OBJECT(o) FROM OrderX o OFFSET ?1 LIMIT ?2</jboss-ql>
It is, in fact, does not translate into a vendor specific SQL syntax but the result set is read taking into account the values. -
2. Re: how to do this kind of jboss-ql?(select top n from....)
malipanchu Sep 17, 2004 10:02 AM (in response to fingertiploneliness)Is this syntax with LIMIT supported in 3.2.3.
Any configuration to be done for this?