假如有如下表：
數(shù)據(jù)若干，root為管理員賬號(hào)，不查。
USER_ID
USER_NAME
PASSWORD
CONTACT_TEL
EMAIL
CREATE_DATE
1
root
123123
13488888888
root
@163.com2011-1-27 23:31:38
2
zhangsan
234234
13588888888
zhangsan
@163.com2011-1-27 23:31:38
3
lisi
345345
13688888888
lisi
@163.com2011-1-27 23:31:38
分頁查詢
select user_id, user_name, password, contact_tel, email, create_date
from
(
select rownum rn, user_id, user_name, password, contact_tel, email, create_date
from
(
select user_id, user_name, password, contact_tel, email, create_date from t_user where user_id <> 'root' order by user_id
) where rownum <= ?
) where rn > ?
本站僅提供存儲(chǔ)服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請
點(diǎn)擊舉報(bào)。
