SELECT top 10 * FROM ( SELECT Posts.Id, Posts.Title, Post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

SELECT top 10 *
FROM
(
SELECT Posts.Id,
        Posts.Title,
        Posts.PostTypeId AS type_id,
        Posts.Score,
        MAX(Score) OVER (partition by Posts.PostTypeId) as max_score,
        RANK() OVER (partition by Posts.PostTypeId ORDER BY Posts.Score) as score_rank,
        RANK() OVER (partition by Posts.PostTypeId ORDER BY Posts.Score) / COUNT(*) OVER (partition by Posts.PostTypeId) as prc
FROM Posts
) AS A
WHERE A.prc between 64 and 88

Enter Parameters

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