oracle SQL分页代码
- WBOY原创
- 2016-06-07 17:46:03883浏览
文章提供一个简单的实现的oracle SQL代码 ，希望对大家有帮助。
/*+ ordered use_nl(t1 t2) */ id, user_id, age, gmt_create
from (select rid
from (select rid, rownum as rn
from (select rowid as rid
from test where user_id = :1
order by gmt_create desc)
where rownum where rn >= :3) t1, test t2
where t1.rid = t2.rowid
声明：
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn