ROWNUM is a Psuedo-Column that returns the the sequence of the row returned. You cannot use it to limit rows since rownum is only incremented after a row is returned in the result set