Top Views questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

List questions with top views

English

Q&A for linguists, etymologists, and serious English language enthusiasts

-- Top Views questions
-- List questions with top views
select top 200 Id as [Post Link], ViewCount, Score, CAST(CAST(ViewCount AS float)/Score AS DECIMAL(10,2)) [Voted by one in] from Posts
where ViewCount > 0 AND Score > 2 AND PostTypeId = 1
order by ViewCount desc

Enter Parameters

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