Hi,
Please follow the link below. This link has information on the syntax of
"Limit clause" for various DB vendors.
http://brainopolis.dnsalias.com/castorwiki/Wiki.jsp?page=OQLLimit
-Banujee
Antonio Capani wrote:
> Hi,
>
> I wonder if it is possible to limit the results of a selection done by
> e
> selection query.
> I am looking for something like:
>
> select x from mytable x where x.id > 3 limit 10 skip 20
>
> this should return no more than 10 results after skipping the first 20
> results
> This feature would help to implement cursors.
>
> I have not found a solution to this problem in the documentation.
Antonio,
Castor currently provides support for the LIMIT clause for MySQL,
PostgreSQL and SQL Server. However, there are no samples of the use of
each implementation. I suggest searching the mailing list archives
available here:
http://www.castor.org/lists.html
Bruce
--
perl -e 'print
unpack("u30","<0G)[EMAIL PROTECTED]&5R\\"F9E<G)E=\\$\\!F<FEI+F-O;0\\`\\`");'
The Castor Project
http://www.castor.org/
Apache Geronimo http://incubator.apache.org/projects/geronimo.html
-----Original Message-----
From: Bruce Snyder [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 4:33 PM
To: [EMAIL PROTECTED]
Subject: Re: [castor-user] oql: how to limit the number of the results?
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged
information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL
PROTECTED] immediately
and destroy all copies of this message and any attachments.
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
