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 about the site for developers and end users of the Sitecore CMS and multichannel marketing software

select displayname, reputation, z.*,y.* from 
(select top (300) id from users order by reputation desc) z
cross apply ( select top(1) score from (select ds.score, postcount=(select count(*) from posts where owneruserid=z.id and score>=ds.score) from (select distinct score from posts where owneruserid=z.id) ds)scorecomp where postcount>=score
order by score desc) y
inner join users on z.id =users.id
order by score desc

fork query

edited apr 22 12 anonymous

created aug 24 11 jon.doe6534