db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Noll <dan...@nuix.com>
Subject Re: getting first k rows from a query that satisfy some additional condition
Date Mon, 27 Oct 2008 21:45:39 GMT
Amir Michail wrote:
> Hi,
> 
> What is a good way for efficiently getting the first k rows from a
> query that also satisfy some additional condition to be determined
> using Java code?

setMaxRows(int) is the standard way of doing this in JDBC, it only falls 
over if you later want to retrieve rows k..(2k-1).

Daniel


-- 
Daniel Noll                            Forensic and eDiscovery Software
Senior Developer                              The world's most advanced
Nuix                                                email data analysis
http://nuix.com/                                and eDiscovery software

Mime
View raw message