empire-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nguyen, Chieu X" <chieu.ngu...@verizon.com>
Subject Building DBCommand
Date Tue, 17 Jun 2014 20:42:36 GMT
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


Mime
View raw message