first 100 rows

obennis

does anybody know how to retrieve only the first 100 rows from a table...I am using SQL Server 7.0.

when I was using postgres I could achieve this task using 'limit' and 'offset' for example I can say

select * from employees offset 0 limit 100;

but SQL Server is different, it only supports 'between...and', which is totally different.

can anybody plz help.

thanks

YappyDog

I'm pretty sure with SQL Server 7.0 you can use the SET ROWCOUNT statement to accomplish what you are after. You would set the ROWCOUNT to 100, execute your sql and then set it back to zero which says return everything. So, you would do:

SET ROWCOUNT 100
select * from employees
SET ROWCOUNT 0

I no longer have SQL Server, so I can't test this out..........

barand

Is it

SELECT TOP 100 .......

obennis

thanks guys, you've been helpful..

but I can only get the first 100 rows like this...how can I get the second set of 100 rows.....in other words from row 101 to row 200.

if i set rowcount to 200, then I will get the whole 200 first rows, but I am only interested in rows 101 to 200....

thanks a lot...😕

barand

I think you may have to get the whole result set and [man]mssql_data_seek[/man]