我心依然

分頁SQL語句

select *
  from wl_news
 where id in (select top 4 id
          from wl_news
         where id in (select top 22－(1-1)*4 id
                  from wl_news
                 order by id asc)
                 order by id desc)
                 order by id desc

posted on 2007-07-01 23:30 Jerry Zhang 閱讀(212) 評論(0)  編輯  收藏