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

Posted to user@empire-db.apache.org by "Nguyen, Chieu X" <ch...@verizon.com> on 2014/06/17 22:42:36 UTC

Building DBCommand

Hi Rainer,

I was wondering how would I write the following SQL using EmpireDB.

select * from (
  select a.*, ROWNUM rnum from (
    <select statemenet with order by clause> // I know how to write this query.
  ) a where rownum <= MAX_ROW
) where rnum >= MIN_ROW

I would appreciate any suggestions.

Thank You,



Chieu Nguyen
Chieu.nguyen@verizon.com