Oracle does not support a limit similar to MySQL. But you can still rownum to limit the number of rows returned by the result set.
If you only want to return the first 10 rows of records, you can write:
SELECT * FROM table WHERE rownum<10;
However, the following statement is not correct:
SELECT * FROM table WHERE rownum>90 and rownum<100;
This is because Oracle believes that this condition is not true and therefore does not return.
You should write this:
SELECT * FROM table WHERE rownum<101;
Minus
SELECT * FROM table WHERE rownum<91;
http://www.bkjia.com/PHPjc/631435.html www.bkjia.com true http://www.bkjia.com/PHPjc/631435.html techarticle Oracle does not support a limit similar to MySQL. But you can still rownum to limit the number of rows returned by the result set. If you only want to return the first 10 rows of records, you can write this: SELECT * F ...