db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Chambers <chamb...@imageworks.com>
Subject Re: top N reporting with derby
Date Thu, 15 May 2008 03:13:56 GMT
Daniel Noll wrote:
> On Thursday 15 May 2008 01:12:21 Six Fried Rice wrote:
>   
>> You can write your query like this:
>>
>> SELECT ROW_NUMBER() OVER() as rownum, spool_table.* FROM spool_table
>> ORDER BY date_inserted WHERE rownum <= 100
>>
>> And it should do the trick. This requires Derby 10.4.
>>     
>
> This is quite interesting.  Is there also a way to do this if you need to join 
> to another table, such that it selects rows 100 to 200 of the first table 
> before doing the join to the second?
>
> Daniel
>
>   
I wasn't able to get that one to run with 10.4, it complained about the 
placement of the WHERE clause.

-- 
-Matt

Cue3 Development Progress 
<http://twiki.spimageworks.com/twiki/bin/view/Software/CueDevelopment> 
Middle-Tier Homepage 
<http://twiki.spimageworks.com/twiki/bin/view/Software/MiddleTier>

Mime
View raw message