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
