>
>SELECT * FROM foo WHERE rownum < 4
>
Note that this will not work if you have any sort of ORDER BY clause because
Oracle uses the rownum clause before the ORDER BY. This is why I posted the
other way of doing SQL Server's version of TOP.
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
