"Nicolas Alvarez" <nic### [at] gmailisthebestcom> wrote in message
news:47b20d36$1@news.povray.org...

> > Is that Oracle? Not offhand familar with it.
>
> No, I'm only familiar with MySQL.
>
> LIMIT {[offset,] row_count | row_count OFFSET offset}
>
> Goes after the WHERE clause.

OK. Haven't done much MySQL either. That looks good for paging then, seeing
as it has an offset. That's one down side of top in SQL server. You can't
ask for the 'next' top 30 easily

Post a reply to this message