Q&A for professional and enthusiast programmers
select * from posts where YEAR(creationdate)>=2008 AND YEAR(creationdate)<2010 order by creationdate asc OFFSET 1150000 ROWS FETCH NEXT 50000 ROWS ONLY