with cte as ( select score as 'Votes', id as [Post Link]...

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

-- Top answers.
-- Highest voted answers.

with cte as (
select
  score as 'Votes',
  id as [Post Link],
  ROW_NUMBER () OVER (ORDER BY score desc) as rn
from posts
where posttypeid = 2
)
SELECT * FROM cte 
WHERE rn BETWEEN 500 and 600;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results