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
[email protected]

Reply via email to