Q&A for people looking to improve their interpersonal communication skills
-- SELECT app_posts.* -- FROM posts -- ORDER BY Id -- OFFSET 3030000 ROWS -- FETCH FIRST 10 ROWS ONLY; -- SELECT TOP 10 * from ( -- SELECT *, ROW_NUMBER() over (order by Id) as r_n_n -- from Posts --) xx where r_n_n >= 3030000 -- SELECT ROW_NUMBER() over (order by Id) as r_n_n, * -- FROM Posts -- ORDER BY Id -- OFFSET 10000 ROWS -- FETCH FIRST 10 ROWS ONLY; SELECT TOP 10 ViewCount FROM Posts ORDER BY ViewCount DESC;