Q&A for professional and enthusiast programmers
declare @pagenum int = 80; select * into #temp from posts where year(CreationDate)=year(getdate()) alter table #temp drop column LastEditDate alter table #temp drop column LastEditorUserId alter table #temp drop column LastEditorDisplayName alter table #temp drop column CommunityOwnedDate select ROW_NUMBER()OVER(order by CreationDate desc) num,* into #out from #temp select * from #out where num between (@pagenum-1)*50000+1 and @pagenum*50000 order by CreationDate desc