Mariores respondedores das minhas perguntas

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow em Português

Perguntas e respostas para programadores profissionais e entusiastas

Select   
  Resposta.OwnerUserId,
  Usuario.DisplayName,
  Count(1) as Qtd

From Posts [Pergunta] 

Inner Join Posts [Resposta] 
  On Resposta.ParentId = Pergunta.Id

Inner Join Users [Usuario]
  On Resposta.OwnerUserId = Usuario.Id

Where 
  Pergunta.OwnerUserId = ##MyUserId## And
  Pergunta.PostTypeId = 1

Group By
  Resposta.OwnerUserId, Usuario.DisplayName
 
Order By Qtd Desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results