0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited oct 24

created oct 24 jesus.calix