db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antonio Gallardo" <agalla...@agsoftware.dnsalias.com>
Subject Re: Query startAt endAt
Date Mon, 17 Nov 2003 18:36:36 GMT
Jakob Braeuchi dijo:
> i also prefer the OFFSET and LIMIT. we do have a problem with dbms only
> supporting OFFSET (oracle, sapdb etc.) there is a way to solve this
> problem by using an enclosing query:
>
> select * from
> (
>    select ... , rownum as ojb_rnum where .... order by ...
> ) where ojb_rnum between OFFSET and OFFSET + LIMIT

Great!

Best Regards,

Antonio Gallardo


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message