SQL分页查询案例

假如有如下表：

数据若干，root为管理员账号，不查。

USER_ID

USER_NAME

PASSWORD

CONTACT_TEL

EMAIL

CREATE_DATE

1

root

123123

13488888888

[e-mail]

2011-1-27 23:31:38

2

zhangsan

234234

13588888888

[e-mail]

2011-1-27 23:31:38

3

lisi

345345

13688888888

[e-mail]

2011-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 > ?