TSQL: SELECT TOP 15 to 30 records?

For 2005 and later, this is probably the best approach:
select * from
(select *, row_number() over(order by col1) seq from Yourtable)
where seq between 16 and 30

I Get an error;

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'where'.

select * from
(select *, row_number() over(order by [ID]) seq from [MyDatabase].[dbo].[MyTable])
where seq between 16 and 30

Select allOpen in new window

I'm using SQL express 2005

thanks

Hi,

How do i filter the results above by another select query, so that only ID that are returned from another select statment below below are returned?

many thanks

SELECT [ID] FROM [MyDatabase].[dbo].[MySecondTable]) Where [best]='5'

Select allOpen in new window

I've opened another question for this;


https://www.experts-exchange.com/questions/24152475/TSQL-SELECT-data-based-on-another-SELECT-Statement.html