|
select *
from
( select row_.*, rownum as rownum_
from
( select p.PARTYID, p.topic, p.title, p.picDir, p.bbsURL, p.publishDate
from TB_PARTYINFO p
order by p.publishDate desc ) row_
where rownum <= 10)
where rownum_ > 5
表示在表TB_PARTYINFO中满足条件的结果集中显示第5到10行的数据 |
原文：http://itren2006.blog.ccidnet.com/blog-htm-itemid-57822-do-showone-type-blog-uid-21308.html
阅读(398) | 评论(0) | 转发(0) |
