TSQL SELECT Question

I want to get results from a specified row to another specified row like:


row 1 to row 10


row 11 to row 20





i don't know how the TSQL code would look like:


SELECT FROM [myTable] FROM ROW 1 TO ROW 10





first i tried a column with the following info:


Datatype: int


Identity: Yes


Seed: 1


Identity Increment: 1





and tried the following TSQL code:


SELECT [id], [Column1], [Column2], [Column3] FROM [myTable] WHERE [id] >= '1' AND [id] >= '10'





But it failed when i deleted some rows. Now I wanna change the SELECT form to an appropriate one.





Thanks