0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

select top 100 p.id
, sum(case when v.votetypeid = 2 then 1.0 / datediff(day,getdate(), v.creationdate) else null end) 
from posts p 
inner join votes v on v.postid = p.id
where v.votetypeid = 2 
group by p.id
order by 2 desc

view current version

edited jan 21

created jan 21 rene