1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- RepThreshold: Reputation Threshold "How high their rep should be to be in the list"
select 
  u.Id as [User Link], 
  u.Reputation
from Users as u, Posts as p
where u.Reputation > ##RepThreshold:int?10000## 
  and u.Id = p.OwnerUserId
  and p.PostTypeId in (1, 2) -- question, answer
group by u.Id, u.Reputation
having count(p.Id) = 1
order by u.Reputation desc

fork query

edited aug 18 14 tbodt

created aug 17 14 anonymous