CODE EXAMPLE FOR SQL

sql rownum

Returns results where the row number meets the passed condition.
Example: Returns the top 10 countries from the countries table.
SELECT * FROM countries
WHERE ROWNUM <= 10;