vb.net - How to Select in between row's record from tables in SQL 2008? -

this question has answer here:

• selecting specific row number in sql [duplicate] 2 answers

i wonder, there option "skip"(from linq) in sql select particular rows in table.

i mean, in table named "abcd". in table 300 rows there. 300 rows want select rows 233 300 or 233 258.

how this?? please help.

you can use cte or derived table this:

with cte (     select col1, col2, row_number() over(order sortcolumn) rn     table ) select *  cte  rn >= 233 , rn <= 258