Open Community Wiki Questions with the most Answers and Favorites


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT top 100 P.Title, '' + CAST(P.Id AS nvarchar), 
P.score as Score,
  P.FavoriteCount as Favorites,
  P.ViewCount as [Views]
FROM Posts P
P.CommunityOwnedDate IS NOT NULL
ORDER BY Score desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results