0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited aug 7 20

created aug 7 20 anonymous