select?*?from?(
????select?t.*,rownum?from?(
????????select?*?from?house?order?by?pubdate)?t?)
where?rownum>(currPage-1)*2?and?rownum<=currPage*2我在數(shù)據(jù)庫里直接查的,只有把當(dāng)前頁currPage設(shè)為1的時(shí)候能查出數(shù)據(jù),1以外的其他數(shù)就查不出來了。哪里錯(cuò)了?。?
添加回答
舉報(bào)
0/150
提交
取消