22

select b.* from
( select rownum bnum, a.* from
      (select rownum anum, t.*from abss_greenet_userlog t
      where create_date > to_date('2008-11-25 00:00:00','yyyy-mm-dd hh24:mi:ss') order by create_date desc
      ) a
) b
where bnum >= 1 and bnum < 101 order by anum desc