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.

Ask Ubuntu

Q&A for Ubuntu users and developers

-- 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