Most Valuable Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Displays the highest-ranked questions, based on votes per view.

-- Views: Only view posts above a minimum amount of views of:

SELECT TOP 500 p.ID as [Post Link], p.OwnerUserId as [User Link], p.Tags as [Tags], ViewCount, Score, Round((Score*100.00)/ViewCount, 10) Percentage
FROM Posts p JOIN PostTypes pt on p.PostTypeID = pt.ID
WHERE pt.Name = 'Question' and ViewCount > ##Views:int##
ORDER BY Percentage DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results