limit in select

2006-10-24 Thread Jim Newsham
Hi, Is there a jira issue for adding a limit statement (to limit the number of records returned) to a select statement? I did a jira search but could find no such issue. Id like to vote for it. I also searched the mailing list for discussions regarding this feature, and responses

Re: limit in select

2006-10-24 Thread Bryan Pendleton
Is there a jira issue for adding a limit statement (to limit the number of records returned) to a select statement? I did a jira search but could find no such issue. I’d like to vote for it. Hi Jim, I think DERBY-581 is the issue that tracks this request:

LIMIT with Select Statement

2005-03-16 Thread Devang
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

2005-03-16 Thread Mamta Satoor
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

Re: LIMIT with Select Statement

2005-03-16 Thread Satheesh Bandaram
Derby allows limiting the number of rows returned by a query using JDBC. You can use java.sql.Statement.setMaxRows() method. Satheesh Devang wrote: Hi Is it possible to use LIMIT keyword with select statement? Or is there any other alternative for the same

Re: LIMIT with Select Statement

2005-03-16 Thread Dan Scott
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

Re: LIMIT with Select Statement

2005-03-16 Thread Dan Scott
, 2005 9:19 AM To: Derby Discussion Cc: Derby Development Subject: Re: LIMIT with Select Statement 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

RE: LIMIT with Select Statement

2005-03-16 Thread Bernd Ruehlicke
16, 2005 9:31 AM To: Derby Discussion Subject: Re: LIMIT with Select Statement Bernd: That's not a good assumption. The Derby Project Charter (http://incubator.apache.org/derby/) states: The Derby project develops open source database technology that is: * Pure Java * Easy

Re: LIMIT with Select Statement

2005-03-16 Thread Jeremy Boynes
On a personal note... Bernd Ruehlicke wrote: I assume Derby has to stay in a mode so it is always possible to migrate to DB2 ? - Not that I know of this - I am just throwing the ball in the air to see if anyone is responding to this. Compliance with the SQL standard and building the best damn

Re: LIMIT with Select Statement

2005-03-16 Thread Jean T. Anderson
Mamta Satoor wrote: On Wed, 16 Mar 2005 19:52:56 +0530, Devang [EMAIL PROTECTED] 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