Database & SQL

Add ROWCOUNT to where clause,

e.g.

SELECT *   FROM my_table WHERE ROWNUM <= 100