0

Please login or register to vote for this query.

(click on this box to dismiss)

Your h-index is the highest number n, such that you have at least n questions/answers, all of which have at least n score.

Q&A for professional and enthusiast programmers

select top(0) * from users as u cross apply
(select top(1) p.score from posts  as p
cross apply (select 1 as xyzzy from posts as p2 where (p.owneruserid=p2.owneruserid and p.score<p2.score)) p3
--inner join posts as p2 on (p.owneruserid=p2.owneruserid and p.score<p2.score)
where p.owneruserid=u.id
group by p.score, p.id
having p.score<=count(*)
order by p.score desc) as zzyscore
order by zzyscore.score desc

fork query

edited apr 24 12 kevincathcart

created aug 24 11 jon.doe6534