On 10/15/05, Luke Plant <[EMAIL PROTECTED]> wrote: > > Queries with LIMIT and/or OFFSET probably won't work, because SQL > > Server appears to use "SELECT TOP" instead of LIMIT/OFFSET. Elegant > > solutions to this problem are welcome. :) > > From what I know from one of the more experienced MS SQL Server guys at > work, there isn't an *elegant* solution to this. The one he gave me for > a similar problem involved creating temporary tables - I think a > temporary table with the initial result set plus an index column, then > SELECTing from that. I don't know enough about the architecture of > Django to know whether that is possible.
I can confirm that TOP is all there is. But, something like this might work: select *, identity(8) as "rownum" from table where rownum is between 10 and 20 I'll try to test that, too.