Stack Exchange
log in help

SELECT RANK() OVER(ORDER BY ViewCount DESC) AS RANK FROM ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

DevOps Meta

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT 
  RANK() OVER(ORDER BY ViewCount DESC) AS RANK
FROM Posts
WHERE PostTypeId = 1 AND OwnerUserId BETWEEN 100 AND 200;
view current version

Enter Parameters

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