0

Please login or register to vote for this query.

(click on this box to dismiss)

Perguntas e respostas para programadores profissionais e entusiastas

-- Questions with most views
-- The top 100 questions with the most views

SELECT TOP 100 Id 
AS [Post Link], 
ViewCount,
AnswerCount, 
Score,
CreationDate
FROM Posts 
WHERE ClosedDate is null
AND Id IN (
  SELECT ParentId FROM Posts WHERE OwnerUserId = 5104748
)
ORDER BY ViewCount DESC

fork query

edited jan 27 17 anonymous

created nov 27 12 Edgarator