On Wed, 16 Mar 2005 06:48:16 -0800, Mamta Satoor <[EMAIL PROTECTED]> wrote: > On Wed, 16 Mar 2005 19:52:56 +0530, Devang > <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]&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
