I have a table MyTable (Id, MyText)
I would like to select all from it and order by MyText.
From that list I would like to select rows between @StartNum and @EndNum.
For example if @StartNum=20 and @EndNum=30 then I would select the rows between 20 and 30 from an ordered list. How is best to do this?