Very Computer

I want to limit the number of rows returned by a
select statement. For instance, I would like to be able to
retrieve the records from a select statement in blocks of, lets say
100 records: the first select would return the records 1 to 100,
the second, records 101 to 200, etc.

I know that Oracle has a "rownum" expression that we can use in
a where clause, but could not find anything similar for sql server.

Thanks
CD

there is no such thing as 'rownum' in sqlserver. tables are unordered in
sql.

here is an alternative...

select *, pkid=identity(int,1,1)
into #tmp
from tablename
order by [whatever your want]

select *
from #tmp
where pkid between 101 and 150

-oj

Quote:> Hi All,

> I want to limit the number of rows returned by a
> select statement. For instance, I would like to be able to
> retrieve the records from a select statement in blocks of, lets say
> 100 records: the first select would return the records 1 to 100,
> the second, records 101 to 200, etc.

> I know that Oracle has a "rownum" expression that we can use in
> a where clause, but could not find anything similar for sql server.

> Thanks
> CD