I do TOP quite a lot, so it'd be annoying to have to bury my query in a
sub-query that is "unnecessary"
> Intuitively, you would think so, but it doesn't work that
> way. The sql engine would do the rownum first and then apply
> the order-by clause after.
>
> 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
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
