with post_records as( select *,ROW_NUMBER() over (order b...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

with post_records as(
select *,ROW_NUMBER() over (order by viewcount desc) as 
row from posts where viewcount >40000)
select * from post_records where row <= 50000

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results