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
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:
Hi
Is it possible to use LIMIT keyword with select statement?
Or is there any other alternative for the same?
Thanx
Devang
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
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
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
, 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
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
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
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
10 matches
Mail list logo