Re: SELECT second 25 records

select naam from (
select rownum a,naam from ckv_themas)
where a between 1 and 25
/

did this for me on the first 25,

just replace
where a between 1 and 25 with values 26 and 50 or something

On Tue, 3 Aug 1999 16:01:09 -0500, "Khal" <elsawi_at_xsimple.com> wrote:

>I'm looking for a way to select the second group of 25 matches in a select
>statement.
>
>Any Ideas?
>
>Khal
>
Received on Wed Aug 04 1999 - 02:37:10 CDT