第一段代码查询出9条数据
[code="sql"]select userid as 编号,
username as 用户名,
password as 密码,
createdate as 创建日期,
email as 电子邮箱
from (select t.userid, t.username, t.email, t.createdate, t.password
from o_user t
order by t.createdate desc)
where rownum < 10;[/code][img]http://dl.iteye.com/upload/picture/pic/103620/31c33ca9-6bfa-305e-ba80-f9b0796f9829.png[/img]
但是第二段代码查询出10条 userid=4的一条失踪了 太可怕了
[code="sql"] select * from o_user t;[/code][img]http://dl.iteye.com/upload/picture/pic/103622/c21ef5d6-892e-3b6a-9e67-112a20676701.png[/img]