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

> > Nope. That's paging. Lots of set-based solutions to that (exact
> > implementation depending on the db engine you want to run it)
> >
>
> Like the LIMIT clause?

Is that Oracle? Not offhand familar with it. Is it the equivalent to TOP
(SELECT  top 10 SomeColumn FROM sometable)?

I was thinking the NTile or Row_Number in SQL Server 2005, or the identity
column. Top works, but needs various hoops jumped through to get the second
and subsequent pages.

Post a reply to this message