Settting Ranage with MsSQL

[mr_zog]

I know with MsSQL it does not support the LIMIT feature and I need to use a call like this

SELECT TOP 10 fields FROM table WHERE field = "blah" 

But does anyone know if I can set a range on this? I would like to be able to as I am using the data to plot graphs.

Any help is appreciated!

[Lars_Berg]

range 31-40

select top 10 * from t where pkC not in (
select top 30 id from t order by pkC ) order by pkC

TOP without order by is futile.