How to limit the size of returned result sets in oracle

Oracle does not support limit. however, you can still use rownum to limit the number of rows in the returned result set. if you only want to return the first 10 records, you can write SELECT * FROMtableWHEREROWNUM & lt; 10; but the following statement is incorrect: SELECT * FROMtableWHEREROWNUM & gt; 9 Oracle does not support limit similar to MySQL. however, you can still use rownum to limit the number of rows in the returned result set.

If you only want to return the first 10 records, you can write as follows:

SELECT * FROM table where rownum <10;

However, the following statement is incorrect:

SELECT * FROM table where rownum> 90 and rownum <100;

This is because Oracle does not think this condition is true, so no response is returned.
You should write as follows:

SELECT * FROM table where rownum <101;
Minus
SELECT * FROM table where rownum <91;