0

Please login or register to vote for this query.

(click on this box to dismiss)

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

WITH FewRows AS (
    SELECT *
    FROM Posts
    WHERE PostTypeId=1 AND OwnerUserId BETWEEN 100 AND 200
    )
    
    Select RANK() OVER (ORDER BY ViewCount DESC) AS ViewsRank, *
    FROM FewRows;

fork query

edited sep 27 21

created sep 27 21 anonymous