JSP Insider wrote:
>
> NO, Limit is not standard, I wish it was!!!!
>
> However, it is begining to make its way into more and more databases, I am
> not sure if it is making in with the same format across the databases.
>
> Casey Kochmer
> [EMAIL PROTECTED]
>
> >From: Donald Vandenbeld <[EMAIL PROTECTED]>
> >Reply-To: A mailing list about Java Server Pages specification and
> > reference <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: interesting one, 200 concurent users, large resultstes
> >Date: Thu, 3 Aug 2000 13:57:50 -0600
> >
> >MySQL allows you to use LIMIT in your SELECT statements. With it you can
> >return a portion of the result set (by specifying an offset and the number
> >of rows that should be returned).
> >
> >My question:
> >Is this a 'standard' feature in many production quality databases?
> >
> >Donald
> >
No, it's not, but I wish it not to be. Because you can use cursor for
browsing through resultset, and the data will not be retrieved if you
jump for a number of rows. So you can query all of the rows and retrieve
only interesting ones in every order you want.
--
Regards,
Sergey Vorobiev
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
