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