BlogJava-像鸟儿一样飞翔-最新评论http://www.blogjava.net/lxr5224/CommentsRSS.aspxzh-cnFri, 19 Jan 2007 04:23:36 GMTFri, 19 Jan 2007 04:23:36 GMTcnblogsre: SQL实现排序后分页查询功能（oracle）http://www.blogjava.net/lxr5224/archive/2007/01/17/94463.html#94507JonneyQuestJonneyQuestWed, 17 Jan 2007 13:42:00 GMThttp://www.blogjava.net/lxr5224/archive/2007/01/17/94463.html#94507 select top (pageNum-1)*pageSize id from table
where xxx=xxx
order by xxx,yyy
) order by xxx,yyy

JonneyQuest 2007-01-17 21:42 发表评论
]]>