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 http://mail-archives.apache.org/eyebrowse/[EMAIL PROTECTED]&msgId=2017857 Mamta
