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: Top 1 - Limit 1
Date Sat, 16 Sep 2006 11:50:11 GMT
Tim Dudgeon wrote:
> 
> 
> Marl Atkins wrote:
> 
>> This would only work if the ID field is an Identity.
>> As it happens, it IS so this should work for me too.
>>
>> THREE answers to my problem.
>> You guys are good THANKS!! 
> 
> 
> Yes, but is there an equivalent to the TOP or LIMIT keywords that other
> databases use?

Not in SQL (neither in Derby nor the SQL standard).
The closest equivalent is Statement.setMaxRows(i).

> 
> Tim
> 


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

Mime
View raw message