mssql SELECT TOP

[ravemasta]

I need to select rows 8740 -> 13808

SELECT TOP 13808 FROM TABLE

brings back all 13808 rows. I can't select the range and ORDER BY DESC as their are more rows after the 13808th row.

In mysql I can limit like this LIMIT 8740,13808

How do I get around this in Ms SQL
?

Cheers
Jason

[Sphynx]

Hey, wait a minute...
Since you know the ID of the rows you need can't you just query "SELECT * FROM TBL WHERE ID BETWEEN 8740 AND 13808" ?

BETWEEN checks for values inclusively.

I know you're frustration with this very well. Every time I deal with MSSQL I feel somehow naked without my LIMIT.

Other than BETWEEN, you'd have to find some criteria to filter on so you could subquery ascending then query descending to get the results you need on top.

[ravemasta]

Yep your right. First time using MS SQL so my mind set is still with My SQL.

Cheers
Jason