0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

with relevant_questions as (
  select Posts.Id, Title, Tags, Year(CreationDate) CreationYear, Month(CreationDate) CreationMonth, Score
  from Posts  
  where 1 = 1  
  and PostTypeId = 1
  and Score > 0  
),
ranked_questions as (
  select relevant_questions.*, dense_rank()
  over (partition by CreationYear, CreationMonth order by Score desc) ScoreRank
  from relevant_questions
)
select Id, Title, Tags, CreationYear, CreationMonth, Score
from ranked_questions
where ScoreRank <= 5
order by CreationYear, CreationMonth, Score desc

fork query

created jun 18 Renato Dinhani