- 从表zeeno中“全表扫描”随机抽取10%的记录，随机查询5条记录
SQL>select object_name from zeeno sample(10) where rownum<6;
- 从表zeeno中“采样表扫描”随机抽取10%的记录，随机查询5条记录
SQL> select object_name from zeeno sample block(10) where rownum<6;
本文共 252 字，大约阅读时间需要 1 分钟。
SQL>select object_name from zeeno sample(10) where rownum<6;
SQL> select object_name from zeeno sample block(10) where rownum<6;
转载于:https://my.oschina.net/hengbao666/blog/1563970