You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-user@db.apache.org by Guido Schreuder <g....@xs4all.nl> on 2008/03/03 10:40:36 UTC

Re: ddlutils limit number of results

Hi Tyju,

Have you seen http://tinyurl.com/2gpr9o

kind regards,
Guido


On Fri, 2008-02-29 at 12:22 -0800, tyju tiui wrote: 
> Hi,
> 
> I'm curious if there is currently any method of limiting the number of results returned by a platform.fetch call? For example, say I issue a "SELECT userid, fname, lname FROM users ORDER BY userid DESC" and just want the last ten user's inserted in the db. The query might return 1,000 rows, but I'm only interested in the last 10.
> 
> I know I could do it in the sql code, but then my java code would be that much more dbms dependent. I'd rather let DdlUtils handle it for me in a nice, platform-independent way if possible.
> 
> Thanks,
> 
> Ty
> 
> 
> 
> 
>       ____________________________________________________________________________________
> Looking for last minute shopping deals?  
> Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping