db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: Limiting select results
Date Mon, 27 Nov 2006 09:25:02 GMT
>>>>>>>>>>>> Charlie Babitt wrote (2006-11-25 14:53:23):
> Hallo!
> 
> How can I limit the maximum rows that are returned in a select in apache derby? select
* from table LIMIT 10; (as it works in postgres) gives me a syntax error at 10....
> 
> Any help would be great...

What about statement.setMaxRows(10)

> 
> yours
> charlie
> -- 
> Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
> Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

-- 
Bernt Marius Johnsen, Database Technology Group, 
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

Mime
View raw message