SQL> select * from mike_test0115 where id=11; ID NAME
---------- ----------------------------------------
11 Mike
11 Jimmy
11 a%
11 %
11 %aa
11 test6 行 已选择
SQL> select * from (select * from mike_test0115 where id=11) where rownum<&n;(n=2) ID NAME
---------- ----------------------------------------
11 MikeSQL> select * from (select * from mike_test0115 where id=11) where rownum<&n;(n=4) ID NAME
---------- ----------------------------------------
11 Mike
11 Jimmy
11 a%如果你不制定排序方式的话是随机的
---------- ----------------------------------------
11 Mike
11 Jimmy
11 a%
11 %
11 %aa
11 test6 行 已选择
SQL> select * from (select * from mike_test0115 where id=11) where rownum<&n;(n=2) ID NAME
---------- ----------------------------------------
11 MikeSQL> select * from (select * from mike_test0115 where id=11) where rownum<&n;(n=4) ID NAME
---------- ----------------------------------------
11 Mike
11 Jimmy
11 a%如果你不制定排序方式的话是随机的
5个的rowid,然后从数据中依次返回这5个。你自己可以测试一下