db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <ma...@Remulak.Net>
Subject Re: limit functionality
Date Tue, 04 Jan 2005 15:05:49 GMT
Liam Egan wrote:

> Hello everyone,
> First let me preface this by saying that I'm totally new to derby, having
> said that I am an experienced SQL programmer and have used mySQL
> specifically for a number of years.
> I'm going through and converting a database and all of my queries to derby
> and I have the need to use LIMIT functionality. Or for those of you not
> familiar with mySQL syntax specifically, the ability to fetch x records from
> a point y number of records into the recordset.
> In mySQL I would be able to tack 'LIMIT y,x' onto the end of a query to
> accomplish this, but I can't find any kind of equivilent in derby. I can't
> really use pointers to do this as I'd then be running queries that return
> recordsets with a couple of throusand rows to them and I can't imagine that
> being at all efficient.
> So how do you do it? I can't imagine that it'll be hard as it's one of the
> basic premises of a relational database.
> Thanks.
> Liam.

Hi Liam,

There has been some discussion about this feature on derby-dev.
Following is the url to the discussion


View raw message