1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

SELECT TOP(##num?500##)
RANK() OVER(ORDER BY Score DESC) AS [Rank],
  Id AS [Post Link],
  Score, CreationDate,
  OwnerUserId AS [User Link], OwnerDisplayName,
  CASE PostTypeId
    WHEN 1 THEN 'Question'
    WHEN 2 THEN 'Answer'
  END,
  ViewCount, AnswerCount, Tags, FavoriteCount
FROM Posts
WHERE (PostTypeId IN (##types?1,2##))  
ORDER BY Score DESC

fork query

edited oct 2

created oct 2 Martin20528