Q&A about the site for academics and those enrolled in higher education
--select count(*) from Posts where Posts.ViewCount >= 127754 -- 127500 50140 -- 127700 50030 /* select * from Posts where Posts.ViewCount > 127405 order by Posts.ViewCount desc */ --Max 10062790 --Min 127754 /* select max(A.ViewCount) from ( select top 50000 * from Posts order by Posts.ViewCount desc )A */ --Min 74785 /* select min(A.ViewCount) from ( select top 50000 * from Posts where Posts.ViewCount < 127754 order by Posts.ViewCount desc )A */ /* with cte1 as ( select *, row_number() over(Posts.Id order by Posts.ViewCount desc) rn from Posts where Posts.ViewCount > 0 ) select top 50000 * from cte1 A */ select top 50000 *, row_number() over(partition by Posts.Id order by Posts.ViewCount desc) rn from Posts where Posts.ViewCount > 0