How to limit the size of the returned result set in oracle_PHP tutorial

Oracle does not support limit similar to MySQL. But you can still use rownum to limit the number of rows in the returned result set.
If you only want to return the first ten rows of records, you can write like this:
SELECT * FROM table WHERE ROWNUM<10;
But the following statement is incorrect:
SELECT * FROM table WHERE ROWNUM>90 AND ROWNUM<100;
This is because Oracle believes that this condition is not true, so it does not return.
You should write like this:
SELECT * FROM table WHERE ROWNUM<101;
minus
SELECT * FROM table WHERE ROWNUM<91;

http://www.bkjia.com/PHPjc/629510.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/629510.htmlTechArticleOracle does not support limit similar to MySQL. But you can still use rownum to limit the number of rows in the returned result set. . If you only want to return the first ten rows of records, you can write like this: SELECT * F...