My highest quality answers

3

Please login or register to vote for this query.

(click on this box to dismiss)

An attempt to locate my "best" answers. Very short answers sometimes gain a lot of upvotes, but it can be argued if these are the best answers. This query multiplies body length with score in order to give longer (and presumably more informative) answers more weight.

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

-- My highest quality answers
-- An attempt to locate my "best" answers. Very short answers sometimes gain a lot of upvotes, but it can be argued if these are the best answers. This query multiplies body length with score in order to give longer (and presumably more informative) answers more weight.

SELECT TOP 100
  p.Id,
  p.Id as [Post Link],
  (p.Score * LEN(p.Body)) as [Weighted Score],
  LEN(p.Body) as [Post Length],
  p.Score
FROM Posts p
WHERE
  p.OwnerUserId = ##UserId##
ORDER BY
  [Weighted Score] DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results