1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

-- Getting list of answers for a user by question view
SELECT a.Id as [Post Link], 
       a.Score as "Answer Score", 
       q.ViewCount as "Views", 
       q.Score AS "Question Score"
  
FROM Posts a
JOIN Posts q ON a.ParentId = q.Id

WHERE a.OwnerUserId = ##UserId## AND 
      a.PostTypeId = 2

ORDER BY "Views" DESC

fork query

edited oct 24

created oct 24 MdoubleDash