You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Devang <de...@molecularconnections.com> on 2005/03/16 15:22:56 UTC
LIMIT with Select Statement
Hi
Is it possible to use "LIMIT" keyword with select statement?
Or is there any other alternative for the same?
Thanx
Devang
Re: LIMIT with Select Statement
Posted by Dan Scott <de...@gmail.com>.
On Wed, 16 Mar 2005 06:48:16 -0800, Mamta Satoor <ms...@gmail.com> wrote:
> On Wed, 16 Mar 2005 19:52:56 +0530, Devang
> <de...@molecularconnections.com> wrote:
> >
> >
> > Hi
> >
> >
> >
> > Is it possible to use "LIMIT" keyword with select statement?
> >
> > Or is there any other alternative for the same?
> >
> >
> >
> > Thanx
> >
> >
> >
> > Devang
> >
> >
> >
> >
>
> Hi Devang,
>
> If you search for "Support for SQL Limit?" in the derby developer list
> archive, you will find last set of discussion on the LIMIT keyword.
>
> Here is the url for "Support for SQL Limit?"
> http://mail-archives.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=1065
>
> Mamta
>
Hmm.
Rather than the suggestion from Jeremy Boynes to add LIMIT as a Derby
feature, what about adding a more standard window function feature
like ROW_NUMBER() OVER as described in
http://troels.arvin.dk/db/rdbms/#select-limit ?
Speaking of which, perhaps someone could offer the Derby equivalents
to Troels' comparison of SQL dialects page...
Dan
Re: LIMIT with Select Statement
Posted by Dan Scott <de...@gmail.com>.
On Wed, 16 Mar 2005 06:48:16 -0800, Mamta Satoor <ms...@gmail.com> wrote:
> On Wed, 16 Mar 2005 19:52:56 +0530, Devang
> <de...@molecularconnections.com> wrote:
> >
> >
> > Hi
> >
> >
> >
> > Is it possible to use "LIMIT" keyword with select statement?
> >
> > Or is there any other alternative for the same?
> >
> >
> >
> > Thanx
> >
> >
> >
> > Devang
> >
> >
> >
> >
>
> Hi Devang,
>
> If you search for "Support for SQL Limit?" in the derby developer list
> archive, you will find last set of discussion on the LIMIT keyword.
>
> Here is the url for "Support for SQL Limit?"
> http://mail-archives.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=1065
>
> Mamta
>
Hmm.
Rather than the suggestion from Jeremy Boynes to add LIMIT as a Derby
feature, what about adding a more standard window function feature
like ROW_NUMBER() OVER as described in
http://troels.arvin.dk/db/rdbms/#select-limit ?
Speaking of which, perhaps someone could offer the Derby equivalents
to Troels' comparison of SQL dialects page...
Dan
Re: LIMIT with Select Statement
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Mamta Satoor wrote:
> On Wed, 16 Mar 2005 19:52:56 +0530, Devang <de...@molecularconnections.com> wrote:
...
>>Is it possible to use "LIMIT" keyword with select statement?
>>
>>Or is there any other alternative for the same?
...
> If you search for "Support for SQL Limit?" in the derby developer list
> archive, you will find last set of discussion on the LIMIT keyword.
>
> Here is the url for "Support for SQL Limit?"
> http://mail-archives.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=1065
Also it's FAQ 2.5 at http://incubator.apache.org/derby/faq.html .
-jean
Re: LIMIT with Select Statement
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Mamta Satoor wrote:
> On Wed, 16 Mar 2005 19:52:56 +0530, Devang <de...@molecularconnections.com> wrote:
...
>>Is it possible to use "LIMIT" keyword with select statement?
>>
>>Or is there any other alternative for the same?
...
> If you search for "Support for SQL Limit?" in the derby developer list
> archive, you will find last set of discussion on the LIMIT keyword.
>
> Here is the url for "Support for SQL Limit?"
> http://mail-archives.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=1065
Also it's FAQ 2.5 at http://incubator.apache.org/derby/faq.html .
-jean
Re: LIMIT with Select Statement
Posted by Mamta Satoor <ms...@gmail.com>.
On Wed, 16 Mar 2005 19:52:56 +0530, Devang
<de...@molecularconnections.com> wrote:
>
>
> Hi
>
>
>
> Is it possible to use "LIMIT" keyword with select statement?
>
> Or is there any other alternative for the same?
>
>
>
> Thanx
>
>
>
> Devang
>
>
>
>
Hi Devang,
If you search for "Support for SQL Limit?" in the derby developer list
archive, you will find last set of discussion on the LIMIT keyword.
Here is the url for "Support for SQL Limit?"
http://mail-archives.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=1065
Mamta
Re: LIMIT with Select Statement
Posted by Mamta Satoor <ms...@gmail.com>.
On Wed, 16 Mar 2005 19:52:56 +0530, Devang
<de...@molecularconnections.com> wrote:
>
>
> Hi
>
>
>
> Is it possible to use "LIMIT" keyword with select statement?
>
> Or is there any other alternative for the same?
>
>
>
> Thanx
>
>
>
> Devang
>
>
>
>
Hi Devang,
If you search for "Support for SQL Limit?" in the derby developer list
archive, you will find last set of discussion on the LIMIT keyword.
Here is the url for "Support for SQL Limit?"
http://mail-archives.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=1065
Mamta