So if you do this, select * from users where rownum >=10 and last_name='SMITH' order by last_name, first_name, you might not get exactly what you expect.
If 'smith, andy' is in the 11 th row of the table, he would not show up. On the other hand, 'smith, zack' in the 5 th row, he would show up.
Nick Han
>>> [EMAIL PROTECTED] 02/17/04 12:12PM >>>
> Jeremy, I didn't use the rownum example because in the given
> scenario, using rownum may not give you the latest mod date
> record from the all records in the table.
Won't it give you the first record if you specify an ORDER BY?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
