Everything I've read so far says that Derby does not implement LIMIT which lets you write queries that return only so many rows in the resultset.
Is this still the case or has this changed? Or are there initiatives to implement this? This seems to be a serious limitation when working with large databases and you want to take advantage of Derby in a standalone application. -sud
