Actually rownum doesn't work quite like that.

Tom has a good explanation of what it does. It could be useful in the original poster's case though.

/J