分頁(yè)SQL語(yǔ)句
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 閱讀(215) 評(píng)論(0) 編輯 收藏
posted on 2007-07-01 23:30 Jerry Zhang 閱讀(215) 評(píng)論(0) 編輯 收藏
只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。 | ||
![]() |
||
網(wǎng)站導(dǎo)航:
博客園
IT新聞
Chat2DB
C++博客
博問(wèn)
管理
|
||