0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software quality control experts, automation engineers, and software testers

DECLARE @minscroe int = ##minscore##;
--DECLARE @UserId int = ##UserId##

with gposts as( select postid, creationdate
from (
   select postid, creationdate,
          row_number() over (partition by postid order by creationdate) as rnk
   from votes
   where votetypeid=2
) t
where rnk = @minscroe)
select p.creationdate, datediff(year, p.creationdate, gp.creationdate) 
from gposts gp inner join posts p on gp.postid = p.id

fork query

edited nov 29

created nov 29 anonymous