dead_lee · 2010-08-05 11:44:30 · 阅读: 660 看到老M的憤怒,幫你改下sql.這個方法的好處就在於, 不關你實際的查詢sql如何寫,我就這麼統一包一層就可以分頁了. select rownum() as fno,* from ( select ... where ... order by ... ) a where fno>=1234*100 and fno<1234*100+100
| -ICP -IDC -ISP |