SQL> select * from aa where rownum<11844
2 minus
3 select * from aa where rownum<11834
4 ;
BB
--------------------
2015-12-29 22:40:23
2015-12-29 22:40:33
2015-12-29 22:40:43
2015-12-29 22:40:53
2015-12-29 22:41:03
2015-12-29 22:41:13
2015-12-29 22:41:23
2015-12-29 22:41:33
2015-12-29 22:41:43
2015-12-29 22:41:53
10 rows selected.
SQL>
先有09后有天，伍声只爱冷雨萱
先有结果集，然后有rownum，所以，只有<,<=,!=
阅读(1698) | 评论(0) | 转发(0) |
