I want to retrieve the data between 10 and 20 from a sorted table in SQL.

[WarmSoda]

I want to retrieve data from a sorted table between the 10th and 19th records. How can I do this? I do not want the initial posts to appear when flipping to the 2nd page; only the remaining ones should display.